Possible Deadlocks in the Isolation Level Repeatable Read

In today’s blog posting I want to talk about 2 kinds of deadlocks that can occur when you run transactions in the Transaction Isolation Level Repeatable Read. When you set your transaction to use the isolation level Repeatable Read, SQL Server holds acquired Shared Locks for reading data until the end of the transaction (COMMIT …

Possible Deadlocks in the Isolation Level Repeatable Read + read more