Find the slowest stored procedures with cache statistics, compare CPU and reads, and use two snapshots to isolate one busy hour.
SELECT * in Production Code: The Hidden Costs
See the real costs of SELECT * in production code: lost covering indexes, lookups, stale view metadata, broken inserts and wider results.
SQL SERVER – TempDB in RAM for Performance
TempDB in RAM needs a review of capacity, support and memory pressure. I compare those costs with the bottleneck it would address.
OFFSET FETCH Paging and Its Deep Page Problem
Use OFFSET FETCH with a unique sort order, compare early and deep page reads, and decide when a cursor based approach fits better.
Statistics Histograms Explained
Statistics histograms explained through steps, RANGE_ROWS, EQ_ROWS, and DBCC SHOW_STATISTICS help connect data shape to plan estimates.
Wait Stats Summary: Every Wait on One Page
This wait stats summary puts every wait from the series on one page: what it means and the first fix to try. On Night 28 at the Clipboard Diner, the critic finally comes on an ordinary Tuesday. The lesson of the whole series is the same as the story’s: know what normal looks like on your server.
Wait Stats Troubleshooting: From Top Wait to First Fix
Wait stats troubleshooting comes down to one habit: find the top real wait, ask its first question, and try one fix. On Night 27 at the Clipboard Diner, Casey tapes a one-page chart to the fridge. Here is that chart for SQL Server, plus one query that shows your top waits with their share and signal percent.