Learn T-SQL With Erik: Unfortunate Deadlocks Under Read Committed Locking

In this video, I delve into the world of deadlocks in SQL Server, a topic that often leaves many database administrators frustrated due to its complexity and unpredictability. I demonstrate a unique example where read queries deadlock with write queries, showcasing how even under the default "read committed" isolation level, these types of deadlocks can occur. By creating two simple tables and running a series of transactions, I illustrate this phenomenon in action, highlighting why understanding different isolation levels is crucial for effective database management. CHAPTERS 00:00:00 - Introduction 00:01:29 - Understanding Deadlocks 00:03:21 - Blocking vs. Deadlocks 00:04:56 - Example Deadlock Scenario 00:07:02 - Isolation Levels and Deadlocks ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 TRAINING & COURSES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Get AI-Ready With Erik https://training.erikdarling.com/get-... SQL Server Performance Engineering Course https://training.erikdarling.com/sql-... Learn T-SQL with Erik https://training.erikdarling.com/lear... Everything Bundle: https://training.erikdarling.com/?cou... ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🛠️ CONSULTING & SERVICES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Need SQL Server performance help? https://training.erikdarling.com/sqlc... ━━━━━━━━━━━━━━━━━━━━━━━━━━ 💬 CONNECT ━━━━━━━━━━━━━━━━━━━━━━━━━━ Ask questions at Office Hours https://erikdarling.com/officehours/ Become a channel member    / @erikdarlingdata   ━━━━━━━━━━━━━━━━━━━━━━━━━━