Dead Lock

Question

Hi Friends How can we avoid dead lock situation in SQL Server transactions ?

Shakuntala Gaur · Answer

Hi Please refer the link below. http://www.sql-server-performance.com/2006/blocking/ c heers

Vulpes · Answer

There are some tips in this article for avoiding deadlock: http://mssqlserverindia.blogspot.co.uk/2007/05/how-to-avoid-deadlocking-on-your-sql.html

Satyapriya Nayak · Answer

Hi Shubham Please refer the below links http://www.c-sharpcorner.com/UploadFile/37db1d/understanding-and-handling-sql-server-transaction-deadlocks/ http://www.devx.com/getHelpOn/10MinuteSolution/16488/1954 Thanks