Hi Guys, After migrating data from SQL Server 2000 to SQL Server 2008,when I am doing any a transaction in the table which find out more row on the... Log in Register. Search ...

Learn what a deadlock is, how to detect it, how to resolve it, and how to avoid it in SQL. Follow these best practices and techniques to prevent deadlocks and improve your database performance.

Troubleshooting and resolving SQL Server deadlocks is a common challenge. The first step is to identify the deadlock, and there are several tools available for this task.

-- Scope of a Trace Flag can be either set to Global or Session Only. However, 1204 & 1222 trace flags can be set Global Only. -- Turn deadlock logging on (-1 is global flag) -- Trace Flag 1204:- ...

If a connection triggers a deadlock on SQL Server, the following queries in that connection throw an exception on a transaction descriptor. Additionally, if connection gets to a deadlock, it gets ...

The SQL Profiler has a neat Deadlock Graph feature which is very useful. Let’s take a look…. When SQL Server detects a deadlock, it has to do something about it.