To Re Or Not To Re It’s been a while since SQL Server has had a real RECOMPILE problem. And…
Multitude There are many good reasons to parameterize queries. There are, of course, downsides, too. Parameter sensitivity, AKA parameter sniffing,…
Like vim, I Can’t Quit You I’m going to be honest with you, I have no idea how most people…
No, Not More DMVs Though I would be cool with new ones, as long as they’re not memes. When you’re…
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…
A Plan Has No Name There are so many ways this question gets phrased. Why is my query sometimes slow?…