Build a bounded retry loop for deadlock and lock-timeout errors, roll back each failed transaction, and keep diagnostics beside retries.
SQL SERVER – What is Deadlock Scheduler? How to Reproduce it?
If you have come on this page by internet search, then you must have seen below error in the ERRORLOG which is about deadlock scheduler.
Intra-Query Parallel Deadlock: When One Query Blocks Itself
No error, no deadlock graph, just a report that is slow on some runs. Here is a demo where one query deadlocks with itself, and how to fix it.
Blocking and Deadlock Quiz: Which One Ends by Itself?
This Blocking and Deadlock Quiz asks which problem SQL Server ends on its own, and how the losing session finds out. A two-window test on SQL Server 2025 shows the deadlock error 1205 and the lock timeout error 1222. It also shows how to find a blocker and how to retry.
Funny SQL Server Error Messages and What They Really Mean
Some real SQL Server error messages read like jokes. Here are my favorite funny SQL Server error messages and what each one is really telling you.