Orders commit and the message vanishes? Save both in one transaction, then let a worker claim, send and retry with a lease. Duplicates are still possible.
Snapshot Isolation Update Conflicts: Handling Error 3960
Reproduce snapshot isolation update conflict error 3960, compare read committed snapshot, and retry the whole transaction safely.
Page View Counters: Avoiding Hot Row Contention on Busy Rows
One counter row means every visitor waits in line. See how buckets spread the locks, and why rows on one page can still crowd each other.
UPDLOCK and READPAST for Queue Tables
UPDLOCK and READPAST let SQL Server queue workers claim different rows safely when transactions, retries, and completion rules are designed.
Optimized Locking in SQL Server 2025: What Changes for Blocking
Enable optimized locking in SQL Server 2025 with ADR and RCSI, then compare lock counts and blocking while checking LAQ limits.
SQL SERVER – Difference Between NOLOCK and NOWAIT Hints
Should you use NOLOCK when NOWAIT errors out on a lock? Here is the difference between NOLOCK and NOWAIT, and why neither guarantees a valid answer.
SQL SERVER – Basic Explanation of SET LOCK_TIMEOUT – How to Not Wait on Locked Query
SET LOCK_TIMEOUT works at the connection level, like the NOWAIT hint does for a query. I show how setting it to 0 stops a query from waiting on a lock.