To Re Or Not To Re
It’s been a while since SQL Server has had a real RECOMPILE problem. And if you put it up against the performance problems that you can hit with parameter sniffing, I’d have a …
Category: Plan Cache
When Parameterizing Queries Won’t Help
Multitude
There are many good reasons to parameterize queries.
There are, of course, downsides, too. Parameter sensitivity, AKA parameter sniffing, being the prime one.
But let’s say you consult the internet, or find a consultant on the internet, and they …
sp_BlitzCache: The Law Of Averages
Like vim, I Can’t Quit You
I’m going to be honest with you, I have no idea how most people who use sp_BlitzCache run it.
Most people I talk to are like “oh, that’s not sp_Blitz?”
Ahem.
Anyway, I’m going …
SQL Server Needs Performance Views
No, Not More DMVs
Though I would be cool with new ones, as long as they’re not memes.
When you’re trying to gauge some high level performance metrics on a new server, you probably have your favorite scripts.
They could …
Function Plan Caching: Inlined Functions
Led Better
In yesterday’s post, we looked at MSTVFs. Today, we’re going to look at inlined functions.
And I know, that sounds weird. But it’s because we’re going to circle back to scalar valued functions, and how they’re inlined …
Function Plan Caching: Multi Statement Table Valued Functions
Too Clean
In yesterday’s post, we looked at we looked at simple scalar function plan caching.
Today, we’ll look at MSTVFs. If you’re not sure what that means, look at the title of the post real quick.
Yeah, up …
Function Plan Caching: Scalar Valued Functions
The End Is Nigh-Ish
Yes. SQL Server 2019. Scalar Function Inlining. Froid.
This post isn’t about any of that. It’s about scalar valued functions as we know them now.
Terrible, horrible, no-good, very-bad, presentation-filler.
But to make matters worse, we’re …
What Parameter Sniffing Looks Like In The Plan Cache
A Plan Has No Name
There are so many ways this question gets phrased.
- Why is my query sometimes slow?
- Why does restarting SQL Server make my query fast again?
- Why does clearing the plan cache fix performance?
A while …