QueryTuning

Parameter Sniffing — When the Same Plan Works for One Parameter but Not Another

2026-11-10 · 2 min

A practical introduction to parameter sniffing in SQL Server: how to identify and measure the problem and when to consider PSP, RECOMPILE, or other approaches.