Learn preventing overbooking through a last-seat race, an atomic update, update locks, and a database constraint that rejects oversold inventory.
Errors TRY CATCH Cannot Catch: Compile, Name and Severity Errors
Learn which errors TRY CATCH cannot catch, test execution scopes safely, and pair transaction cleanup with caller timeout handling.
SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions
sys.dm_tran_active_transactions and sys.dm_tran_current_transaction look alike, but one lists active transactions for the instance, the other only your session.
Updating a Large Table in Batches With a Moving Key Range
Walk the clustered key a slice at a time, log each batch, and learn why stopping at the first empty batch quietly leaves rows behind.
Service Broker Queue: Diagnose a Disabled Receiver
A disabled Service Broker receiver needs diagnosis before recovery. Read queue flags alongside application evidence, distinguish state from cause and check receiving, enqueueing, activation and poison-message handling separately.
SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept
Two ideas with examples: transactions have no effect on local variables, and an UPDATE applies all its changes at once, which lets you Swap Variables in one go.
SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks
How do you find which table has a transaction lock and what lock type it is? Imran Mohammed explains it for SQL Server 2000 and 2005, and how to avoid locks.