Kendra Little has a couple queries to force deadlocks in the WideWorldImporters database:
SQL Server’s deadlock manager woke up, looked around, and saw that our two session windows were stuck. They each were requesting locks that the other session wouldn’t give up– and if the deadlock manager didn’t break the deadlock, they’d be stuck there forever.
I didn’t set the deadlock priority on any of my transactions, so the deadlock manager picked the session that it thought would be the least work to roll back– and it became the victim.
Read on for the scripts and also some hints to help you learn more about deadlocks.