“Deadlocks are the result of application code combined with a database schema that results in an access pattern that leads to a cyclical dependency.”
Source: Geek Speak: The Cause of Every Deadlock in SQL … | THWACK
The Cause of Every Deadlock in SQL
Published
https://stackoverflow.com/questions/7813321/how-to-deliberately-cause-a-deadlock