Further From Truth
Estimated plans can be a bit confounding, huh?
Whether you see one by hitting CTRL+L, looking in the plan cache, or looking in Query Store, the song remains the same.
The query is slow: sometimes? always? usually? …
Category: Plan Cache
Whose Plan Handle Is It Anyway?
End Of The Line
There are a lot of words you can use to describe Extended Events. I’ll skip over my list to keep the blog family friendly.
In this post, we’re going to look at how two event can …
Is RECOMPILE Really That Bad?
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 …
Are Long Compile Times Bringing You Down?
Rarities
I ran into a very funny situation while working with a client recently. They were using Entity Framework, and a query with around 10 left joins ended up with a compile time of nearly 70 seconds.
Once the query …
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 …
A Quirk With Plan Caching And Dynamic SQL
Have All Thirteen
…
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 …