Deadlocked!: "read committed snapshot" Explained
I just recently read Jeff Atwood’s Deadlocked! article. I just wanted to give some more insight in to the read committed snapshot so that it is not perceived as “magic”. It has some definite advantages when dealing with deadlocks, however if your code relies on row level locking you are not going to be able to use this type of reading in SQL Server. First lets talk about how you enable it. It is not a transactional isolation level, so if you set it, it will effect your whole database. You have been warned! ...