A multi-row INSERT adds several rows with one statement, using a list of value groups separated by commas. This post compares it with separate INSERT statements on a small table of books. It shows that one bad row undoes the whole statement, and it covers the errors and the 1,000 row limit.
Destructive Reads: Pulling Work From a Queue Table With OUTPUT
Claiming a job and finishing it are two different things. Try a delete claim, a rollback, and an update claim on a tiny queue.
Optimized Locking Wait Stats: New Lock Waits in SQL Server 2025
Optimized locking wait stats are the new lock waits SQL Server 2025 records when optimized locking is on. On Night 24 at the Clipboard Diner, a new state code swaps booth cards for wristbands. Then I show what LCK_M_S_XACT_MODIFY and LCK_M_S_XACT_READ mean, how to check the setting, and why a long transaction still hurts.
HADR_SYNC_COMMIT Wait Stats: Availability Group Commits
HADR_SYNC_COMMIT wait stats measure how long a commit waits for a synchronous secondary replica to harden the log. On Night 22 at the Clipboard Diner, every sale is phoned to a sister diner before the plate can leave. Learn what the wait includes, how to read the send and redo queues, and the fixes from the secondary’s log disk to asynchronous commit.
LOGBUFFER Wait Stats: When the Log Buffer Fills
LOGBUFFER wait stats mean a task is waiting for free space in the log buffer before it can write a log record. On Night 18 at the Clipboard Diner, Pat’s notepad fills up faster than Pat can copy it into the order book. Then two queries show whether your log can keep up, and the fixes in order.
WRITELOG Wait Stats: Transaction Log Flush Waits
WRITELOG wait stats measure the time a commit waits for its log records to reach the disk. On Night 17 at the Clipboard Diner, Pat’s pen slows down and plates pile up at the pass. Then two queries show your log write latency, and a short script shows why many tiny commits hurt.
LCK_M Wait Stats: Lock Waits and Blocking
LCK_M wait stats show how long queries wait for a lock that another session holds. On Night 15 at the Clipboard Diner, a party in booth 7 pays and then won’t leave, and three parties wait behind it. Then two queries find the blocking chain and its head blocker on your own server.