The 64 MB rule says log file growth can skip zeroing when instant file initialization is on, but only up to 64 MB. Two trace flags make the SQL Server error log show a 64 MB growth skipping the zeroing and a 65 MB growth zeroing in full. The last section says what to change.
statement_start_offset: Showing the Exact Statement Running Now
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.
SQL Server: How to Display Row Numbers in Query Editor for Efficient Query Editing
Let us learn how to Display Row Numbers in Query Editor for Efficient Query Editing. Comprehensive Database Performance Health Check
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.
TRY_CAST vs CAST: Finding Rows That Will Not Convert Before a Load
Find text values that will not convert before loading, separate invalid and missing input, and use explicit date styles and culture parsing.
INSERT EXEC: Capturing a Procedure’s Result Set and Its Limits
Capture rows with INSERT EXEC, match result columns, understand nested and multiple-result limits, and choose supported alternatives.