How to Check and Resolve a Deadlock in SQL Server
The dreaded ‘Event ID 1205’ – your transaction has been deadlocked. But what does this mean exactly, and what steps can you take to prevent this from happening again in the future? To begin, let’s look at how a deadlock occurs. When SQL Server tasks are performed simultaneously and block each other. As a result, … Read more How to Check and Resolve a Deadlock in SQL Server
