“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