Read automatic plan correction advice, compare regressed and recommended plans, and verify that forcing the last good plan held.
Grouping by query_hash to Find Cheap Queries That Cost the Most
Group cached statements by query_hash to find high total CPU and reads, compare plan hashes, and account for missing cache history.
query_store_query_text: Searching Query History by Statement Text
A LIKE search on Query Store text is a good first step, but one search found four statements, including itself. I show how to narrow it down to the real history.
Parameter Sensitive Plans: Reading Query Variants in Query Store
Inspect query variants and dispatcher plans in Query Store, compare skewed parameter values, and read the boundaries selecting each plan.
Free Tools Worth Knowing for SQL Server Work
Free tools for SQL Server work include Microsoft editors, built-in diagnostics, and community scripts; learn the job each handles and its limits.
Plan Guides: Fixing a Query You Cannot Change
Apply plan guides to a parameterized query you cannot edit, validate the guide, confirm plan matching, and compare Query Store hints.
CE Feedback for Expressions in SQL Server 2025
Inspect CE feedback for expressions in SQL Server 2025, check compatibility and Query Store, and observe repeated execution evidence.