ACID in SQL Server: what it is, how it works, and how to live more adventurously.
summary
A concise primer on ACID for SQL Server that focuses on Isolation levels: read uncommitted, read committed, repeatable, serializable, snapshot and RCSI with live demos: a bank-transfer shows no lock dirty read demo and blocking behavior, a repeatable vs serializable phantom example, a troublesome merge + HOLDLOCK deadlock case resolved by switching to read committed, deadlock victimization and retry advice, plus coverage of transaction log hardening, delayed durability risks and tempdb growth for snapshot isolation. Practical, demo-driven and troubleshooting-focused.
AI-written summary · about
chapters (13)
- 0:00ACID overview
- 1:12ACID in SQL Server
- 4:28Isolation levels
- 10:50Read committed isolation
- 11:33Repeatable read and phantoms
- 16:13Serializable isolation
- 24:06Isolation trade-offs
- 25:27Deadlocks in SQL Server
- 33:18Deadlocks with merge
- 41:47Snapshot isolation
- 47:04Durability and transaction log mechanics
- 49:10Delayed durability
- 50:36Key takeaways
related talks
52mACID in SQL Server: what it is, how it works, and how to live more adventurously.- 52mACID in SQL Server: what it is, how it works, and how to live more adventurously.
38mThe I in ACID
52mTransactions: Myths, Surprises and Opportunities
41mThe I in ACID
47mMaximizing Database Performance With Isolation Levels- 47mMaximizing Database Performance With Isolation Levels
01mDon't Drop ACID - Transactions in Distributed NoSQL