Detained
Despite the many metric tons of blog posts warning people about this stuff, I still see many local variables and optimize for unknown hints. As a solution to parameter sniffing, it’s probably the best choice 1/1000th of the time. …
Category: Parameter Sniffing
Parameter Sniffing Is Usually A Good Thing
Tick Tock
I talk to a lot of people about performance tuning. It seems like once someone is close enough to a database for long enough, they’ll have some impression of parameter sniffing. Usually a bad one.
You start to …
Recompile And Nested Procedures
Rock Sale
While I was answering a question, I had to revisit what happens when using different flavors of recompile hints with stored procedure when they call inner stored procedures. I like when this happens, because there are so …
Defeating Parameter Sniffing With Dynamic SQL
Enjoy!
Thanks for watching!
A Word From Our Sponsors
First, a huge thank you to everyone who has bought my training so far. You all are incredible, and I owe all of you a drink.
Your support means a …
A Suggestion To Make Lookups Less Painful
Odor Of Gas
One problem with Lookups, aside from the usual complaints, is that the optimizer has no options for when the lookup happens.
If the optimizer decides to use a nonclustered index to satisfy some part of the query, …
A Parameterization Puzzle With TOP Follow-Up
Spell It Out
Back in October, I had written a couple posts about how parameterizing TOP can cause performance issues:
Anyway, I got back to thinking …
Join Me At Data Platform Summit 2020!
The Road From Nowhere
This year, I’m teaching an 8 hour online workshop at Data Platform Summit, and I’d love it if you joined me.
Here’s what I’ll be teaching:
Class Title: The Beginner’s Guide To Advanced Performance Tuning…
Reasons Your Query Is Slow Right Now: A Bad Plan Appears
Update Stats, They Said
Okay look, you probably should update stats. At least when you do it, you have some control over the situation.
If you let SQL Server get up to its own devices, you might become quite surprised.…
Reading, Locking, Sniffing
Make It Out
I’m going to show you something bizarre. I’m going to show it to you because I care for your well-being and long term mental health.
Someday you’ll run into this and be thoroughly baffled, and I want …
Troubleshooting Parameter Sniffing With sp_WhoIsActive
THANKS ADAM
…