A missing index suggestion means more when you can see its query. Here is how to link them, trim the text and test the index.
Unstable Queries: Finding Wide Duration Swings in Query Store
Find unstable queries with Query Store duration spread, weight averages, and separate plan changes from waits and parameter effects.
SQL SERVER – Does Use of CTE Change the Order of Join in Inner Join
A reader said he uses a CTE to control join order. Does a CTE change the order of join in an inner join? Here is what I found.
Exponential Backoff: How SQL Server Estimates Several Filters
The plan guessed 89 rows and 500 came back. Here is the rule behind that guess, and what to do about it.
SSMS Keyboard Shortcuts Worth Learning
SSMS keyboard shortcuts for execution, comments, results, and Object Explorer remove repeated clicks while keeping query context visible.
Nested Loops Join: When It Is the Right Choice
Loops in a plan are not always the villain. Count the inner executions and the reads before you force another join type.
Reading DBCC SHOW_STATISTICS Step by Step
Read SHOW_STATISTICS headers, density and histogram boundaries, compare estimates with your plan, and query the histogram directly.