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.
Related Posts
- Indexed Views As Filtered Indexes In SQL Server
- Considerations For Implementing Soft Deletes In SQL Server
- Getting The Top Value Per Group With Multiple Conditions In SQL Server: Row Number vs. Cross Apply With MAX
- Getting The Top Value Per Group In SQL Server: Row Number vs. Cross Apply Performance
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!
Yep, totally, but they can be tricky to get working. Forced Plans in Query Store are a bit easier.