Apply plan guides to a parameterized query you cannot edit, validate the guide, confirm plan matching, and compare Query Store hints.
Forced Parameterization: When It Cuts CPU and When It Hurts
Test forced parameterization against ad hoc compile pressure with query_hash counts, compilations per second, CPU, and parameter sensitivity.
SSRS Parameters That Do Not Slow Reports
SSRS parameters work best with selective defaults, compact value lists, and SQL queries that preserve useful indexes under real filters.
Stored Procedure Recompile Quiz: What Forces a New Plan?
This Stored Procedure Recompile Quiz asks which action makes SQL Server build a new plan for a procedure. The answer is a new index on a table it reads. A tested script uses plan counters to show what reuses the plan and what rebuilds it.
OPTIMIZE FOR and RECOMPILE Hints Compared
OPTIMIZE FOR and RECOMPILE address parameter-sensitive plans differently; compare stable representative values with per-run compilation cost.
Filtered Indexes and Where They Help
Filtered indexes help SQL Server target active rows in a larger table; learn useful predicates, parameter limitations, and how to verify plan choices.
Why One Query Has Two Cached Plans: SET Options and plan_attributes
Investigate two cached plans with plan_attributes, decode differing SET options, and match application settings before diagnosing skew.