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…
What This Isn’t I’m not writing about how if you use NOT IN, and suffer from NULL values in a…
Multitude There are many good reasons to parameterize queries. There are, of course, downsides, too. Parameter sensitivity, AKA parameter sniffing,…
Unavoidable Having some key lookups in your query plans is generally unavoidable. You’ll wanna select more columns than you wanna…
Lost In The Woods When you find unused indexes, whether using Some Script From The Internet™, sp_BlitzIndex, or Database Telepathy,…
Happy Little Operators This month’s T-SQL Tuesday is a fun one. There’s only one problem: I’ve already blogged about my…