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…
Unavoidable Having some key lookups in your query plans is generally unavoidable. You’ll wanna select more columns than you wanna…
Facts Yesterday we looked at how unused indexes can muck up the buffer pool, because writes to them will bring…
Lost In The Woods When you find unused indexes, whether using Some Script From The Internet™, sp_BlitzIndex, or Database Telepathy,…
To Taste Indexes remind me of salt. And no, not because they’re fun to put on slugs. More because it’s…
Grey Matter Often when query tuning, I’ll try a change that I think makes sense, only to have it backfire.…
Will Travel If you recall yesterday’s post, we added a couple two column indexes to the Posts table. Each one…