How To Write SQL Server Queries Correctly: Where Clauses With OR In Them

[@SQLDevDBA]

Awesome video! Thanks very much!

[@FlaggedStar]

13:07 This feels like one big jab at sp_BlitzIndex's mode 3.

[@ErikDarlingData]

Hahaha, no, just the people who copy and paste from it without any due diligence.

[@Cahangir]

Not sure if I could think of UNION ALL in that situation but regardless, thanks for the tip. Hope I'll use it sometime

[@ErikDarlingData]

Once you get going with it, it gets easier and more intuitive.

[@marwanhefnawy1137]

Why don't you use SQL Sentry Plan Explorer for examining your execution plans? I think it is more clear than the built in tool in ssms

[@ErikDarlingData]

I've only ever found it useful for long stored procedures. In recent years it has not kept up with SSMS in exposing various query plan details. Solar Winds has really dropped the ball on it. The last couple versions won't even open up on my computer, they just crash instantly.

[@wplegend]

Would the expanded query with the union all be good to keep instead of the or, or are there performance implications?

[@ErikDarlingData]

I'd generally opt for the union all query for a number of reasons.

[@wplegend]

@ErikDarlingData thanks!