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…
Training Daze I’ve delighted to announce that I’ve been selected to present a full day session for SQL Saturday Portland.…
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,…
No, Not That
Buggery If you seriously want to debug, you’ve gotta use something like WinDbg. It’s tough, but powerful. It’s also… Where…
Gritty You may occasionally see in your favorite monitoring tool, or Most Fantastic And Glorious Script For Determining Whom Activity…
Led Better In yesterday’s post, we looked at MSTVFs. Today, we’re going to look at inlined functions. And I know,…
Too Clean In yesterday’s post, we looked at we looked at simple scalar function plan caching. Today, we’ll look at…