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…
Lost In The Woods When you find unused indexes, whether using Some Script From The Internet™, sp_BlitzIndex, or Database Telepathy,…
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…
The End Is Nigh-Ish Yes. SQL Server 2019. Scalar Function Inlining. Froid. This post isn’t about any of that. It’s…
Happy Little Operators This month’s T-SQL Tuesday is a fun one. There’s only one problem: I’ve already blogged about my…
Grey Matter Often when query tuning, I’ll try a change that I think makes sense, only to have it backfire.…
Outline In SQL Server 2019, a few cool performance features under the intelligent query processing umbrella depend on cardinality estimation.…
Will Travel If you recall yesterday’s post, we added a couple two column indexes to the Posts table. Each one…