A stored procedure runs for forty minutes and you need the busy line. Here is how to pull it out of the batch text without the usual off-by-two mistakes.
Performance Tuning Mistakes in SQL Server: 11 Habits to Fix
Performance tuning mistakes are habits, and each one has a check. Eleven sit in one table, and five are measured on a demo database: a missing index, stale statistics, a row by row loop, a giant delete and a type that cannot be indexed.
Updatable Ledger Tables: Proving No One Quietly Changed a Row
Update a row in a ledger table and the old version stays. Then verify the history with a digest, and break the digest to see what failure looks like.
Turning Per-Second Counters Into Real Rates From DMVs
That per-second counter on your dashboard is probably a running total. Here is how to turn it into a real rate with two samples.
Finding Schedule Clashes: Overlapping Sessions per Attendee
An attendee says two sessions run at the same time. Here is how to find every overlapping pair once, and why touching is not a clash.
Query Store Interval Length: Choosing How Fine Your History Is
An hourly average can hide the slowdown users remember. Here is a small demo of Query Store interval length and how to choose it.
Will the Next Autogrowth Fit? Checking Growth Against Free Disk
The drive has free space, yet the file will not grow. Here is how to calculate the next autogrowth and test it against disk and MAXSIZE.







