Query Store hints leverage Query Store to provide a method to shape query plans without changing application code. Now are available in SQL Server 2022
You already know you have parameter sniffing issues, and now you need to figure out how to fix it. Learn how we resolve bad Parameter Sniffing with Query Store in SQL 2016/17/19 and how it can be resolved more efficiently and easy with Query Store hints in SQL 2022, to reduce the blast radius with index changes, query tuning, and database-level settings. I will discuss whether you should use Query Store hint or Parameter sensitive plan optimization, also new in SQL 2022 and it is also based on Query Store.
This is a maximum demo session with minimum theory and real experience over more than 24 year!