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: Parameter Sniffing
SQL Server 2019: Is Bigger Better?
Outline
In SQL Server 2019, a few cool performance features under the intelligent query processing umbrella depend on cardinality estimation.
- Batch Mode For Row Store (which triggers the next two things)
- Adaptive Joins
- Memory Grant Feedback
If SQL Server …
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 …
Are Self Joins Ever Better Than Key Lookups?
Sorta Topical
Like most tricks, this has a specific use case, but can be quite effective when you spot it.
I’m going to assume you have a vague understanding of parameter sniffing with stored procedures going into this. If you …