From Dev.to
How to Fix SQL Server Deadlocks: Causes, Detection and Real Fixes
Originally published at SQL & Cloud Lab. A deadlock happens when two sessions each hold a lock the other one needs. Neither can continue, so SQL Server picks one as the victim, rolls its transaction b...