Question: Why Query Store Actual Operation Mode is Not Same as Requested? Query Regression (poor performing queries, once working great)
Automatic Plan Correction: Reading SQL Server’s Tuning Advice
Read automatic plan correction advice, compare regressed and recommended plans, and verify that forcing the last good plan held.
SQL Authority News – SQL Server 2017 and Automatic Tuning
SQL Server 2017 becomes generally available on Oct 2. Here are my thoughts on rapid releases and on Automatic Tuning, the feature I most want to try.
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.
Top Resource Consumers in Query Store
Top resource consumers in Query Store show CPU, duration, and reads by query and plan, so tuning starts with workload impact.