"Fixes in Order of Bluntness"

1. What is the first step you should take when addressing query plan instability due to parameter sniffing?

Apply OPTION (RECOMPILE) hint Update statistics or check for missing indexes Use LOCAL variables Force a specific plan using Query Store

2. Which of the following options allows for plan recompilation at each execution of a query?

OPTIMIZE FOR UNKNOWN OPTION (RECOMPILE) FORCE PLAN Query Store hints

3. If a report runs with a specific parameter shape 95% of the time, which fix would be most appropriate to maintain predictable performance?

FORCE PLAN OPTIMIZE FOR UNKNOWN OPTION (RECOMPILE) OPTIMIZE FOR (specific value)

4. What is the primary risk associated with using the option to disable parameter sniffing for an entire database?

Improved performance for all queries Loss of optimization for individual queries Increased compile times Greater plan stability