This statement is trying to acquire gap lock (from 1 to infinity), but T2 is waiting record-lock(id=1) in the queue, so it should wait for T2. Deadlock happens. Even T1 has record-lock(id=1), it can't even get this gap lock as T2 is waiting in queue. Share Improve this ans...
17 Resolving deadlock from 2 tables only related through indexed view 6 Should an INSERT cause an exclusive lock on a foreign key? 5 SQL Server Exclusive(X) lock not consistently blocking Shared(S) lock on a resource 1 Why is a Shared lock blocking on an IX lock when Read Committe...