T-SQL coding

Should I use an “OR” in a JOIN?

Conditional Joins…I don’t see much about this topic in cyberspace, but I occasionally run into performance problems with them.  So this posting is all about them…or more specifically about why you should avoid them. A conditional join is a join (either inner or outer, by the way) that contains an “either-or” condition, easily identified because… Continue reading Should I use an “OR” in a JOIN?