Defeating Parameter Sniffing With Dynamic SQL In SQL Server

Enjoy!


Thanks for watching!

Going Further


If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.



2 thoughts on “Defeating Parameter Sniffing With Dynamic SQL In SQL Server

  1. Hi Erik. Amazing post as well as all your video courses. This is a great solution to fight parameter sniffing for the queries you are allowed to modify. But what about for the code you simply cannot touch? Would be Plan Guide an option for that? Happy holidays and thank you for sharing your knowledge!

Comments are closed.