Raised Right It seems like every time I check out a server, the query plans are a nightmare. Users are…
PAUL WHITE IS WRONG Ha ha. Just kidding. He’s never wrong about anything. But he did write about Eager Index…
A Certain Ratio I have a lot to say about this demo on SQL Server 2019, which I’ll get to…
Tell It To The Judge A common dilemma is when you have two date columns, and you need to judge…
Pattern Baldness I see this pattern quite a bit in stored procedures, where the front end accepts an integer which…
Old Habits Let’s say you’re on SQL Server 2019. No, seriously. It’s been out for a couple weeks now. You…
What This Isn’t I’m not writing about how if you use NOT IN, and suffer from NULL values in a…
Quarrelin’ The next time you’re writing a query, I want you to try something in your head: Break the columns…
No, Not More DMVs Though I would be cool with new ones, as long as they’re not memes. When you’re…
Unavoidable Having some key lookups in your query plans is generally unavoidable. You’ll wanna select more columns than you wanna…