Some good guides about SQL Server deadlock?

I am researching SQL Server deadlock, about why deadlock exists, how to solve deadlock problem, best practices, how to analyze why deadlock occurs.

I am working on SQL Server 2008 Enterprise. Any recommended readings for me?

Thanks in advance, George

+2


source to share


2 answers


read this article.



Bye.

+4


source


InformIT has a pretty good introductory article on transactions and locking. MSDN also has a good overview of transactions and their use.



+2


source







All Articles