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
sql sql-server sql-server-2008 deadlock


source to share


2 answers


read this article.



Bye.

+4


source to share


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



+2


source to share







All Articles
Loading...
X
Show
Funny
Dev
Pics