Posted inSQL Server

Creating a Deadlock

Previously we have looked at how to capture a deadlock, but how do we go about creating a deadlock? I think the following is the simplest method: 1. Create two…
Posted inSQL Server

SQL Server Locks

Here is a simple script to get some more detailed information about locking, which I have added to over the last few years.
Posted inSQL Server

Capturing Deadlocks

So, deadlocks. "A deadlock occurs when two or more tasks permanently block each other by each task having a lock on a resource which the other tasks are trying to…