Configure DOP feedback in SQL Server 2022, check Query Store evidence, and compare parallelism changes with your workload and MAXDOP limits.
Query Store Capture Modes: ALL, AUTO and CUSTOM
Choose a Query Store capture mode for your workload, inspect ALL, AUTO, CUSTOM and NONE, and tune thresholds without losing useful history.
OPTION (FORCE ORDER): When a Join Order Hint Helps and Hurts
Test OPTION (FORCE ORDER) against real join plans, see when fixed table order helps or hurts, and apply a reversible Query Store hint.
Compatibility Level 170: What SQL Server 2025 Turns On
Move to compatibility level 170 on SQL Server 2025 with feature checks, Query Store baselines, plan comparisons, and a rollback plan.
Finding Which Statistics a Query Used in the Execution Plan
Find which statistics a query used through OptimizerStatsUsage in actual-plan XML, cached plans, and Query Store history.
Query Store Hints: Fixing a Query Without Touching Its Code
Apply query store hints to a vendor query without code changes, verify failures and plan behavior, then clear the hint after the real fix.
Finding the Worst Query in Five Minutes With Query Store
Find the worst query with Query Store totals, compare CPU and duration over the last day, inspect plans, and choose the first tuning target.