SQL Server deadlock: build one, then remove it

Run one step from each session, then request the second row from both. Switch the lock order and try again.

Back to blog.sqlauthority.com