A demo script for keeping CPU busy: I wrote this query at an event to simulate high CPU usage, and it pushed CPU from 10% to 80%.
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.
OLEDB Wait Stats: Linked Servers and Remote Calls
OLEDB wait stats measure the time SQL Server spends in calls to an OLE DB provider, and that usually means a linked server. On Night 23 at the Clipboard Diner, the pie case is empty and Jules crosses the street for every slice. Learn how to find the waiting session, how OPENQUERY filters on the remote side, and when to keep a local copy instead.
ASYNC_NETWORK_IO Wait Stats: When the Application Is Slow
ASYNC_NETWORK_IO wait stats mean SQL Server has results ready and is waiting for the application to read them. On Night 21 at the Clipboard Diner, hot plates pile up at the pass while Quinn tells a long story at table 4. Learn the causes in the order I find them, two queries that name the slow program, and why the fixes live in the application.
MSQL_XP Wait Stats: Extended Procedures and External Code
MSQL_XP wait stats measure the time a query waits while an extended stored procedure such as xp_cmdshell or xp_dirtree runs. On Night 20 at the Clipboard Diner, an outside caterer takes over one station behind a curtain. Then two queries show you which session is waiting and which procedure it called, and the fixes move that work outside SQL Server.
EXISTS: A Row Containing NULL Still Exists
EXISTS answers whether qualifying rows exist. Keep missing values separate from missing rows and preserve the intended correlation.


