DBA

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.

Query Store After Migration — How to Detect Execution Plan Regressions

2026-11-03 · 2 min

Use SQL Server Query Store after migration to compare plans, identify regressions, and respond safely to performance problems.