Capture the last actual execution plan with LAST_QUERY_PLAN_STATS, inspect runtime rows, and understand what cache retention cannot provide.
Why Queries Recompile
Why queries recompile becomes clearer when you capture Extended Events causes and check schema changes, statistics, SET options, and temp tables.
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.
SQL SERVER – Introduction of Showplan Warning
SQL Server can be your performance tuning teacher. Vinod Kumar explains the Showplan Warning in execution plans and what each warning is telling you.
Uneven Parallelism: Spotting Skewed Threads Behind CXPACKET Waits
Diagnose uneven parallelism by comparing CXPACKET and CXCONSUMER with per-thread row counts in plans and live query profiles.
SQL SERVER – Video – Beginning Performance Tuning with SQL Server Execution Plan
Performance tuning is a long journey, and the Execution Plan is its map. A video on how to begin tuning queries with SQL Server execution plans.
Why a Clustered Index Does Not Guarantee Order Without ORDER BY
Explain order without ORDER BY through parallel scans, NOLOCK allocation scans, alternate indexes, shared scans, and the explicit sort fix.