Defeating Parameter Sniffing With Dynamic SQL
2022TL; DR
A Great Solution For A Hard Problem
Session Details
Parameter sniffing can be a huge performance problem, and fixing it can feel like an exercise in futility.
If you're ready to go beyond recompiles and unknowns and solve problems for real, come to this session.
I'll teach you techniques to fix parameter sniffing problems for good.
3 things you'll get out of this session
Speakers
Erik Darling's previous sessions
The SQL Server Performance Tasting Menu
Delicious Demos For Doubting Developers
What Else Can Indexes Do?
No pictures of phone books, here. We're gonna look at the way indexes change query behavior for better... and worse.
Improving SELECT * Query Performance
For anyone frustrated by column-hoarding users and developers