SET STATISTICS PROFILE ON 显示query的执行过程

 

Troubleshooting Deadlocks

 

Understanding Locking in SQL Server

 

对锁的初步认识

 

深入的探讨锁机制

 

3种跟踪死锁的方法总结

 

Deadlock Troubleshooting Part1

 

Deadlock Troubleshooting, Part 2

 

Deadlock Troubleshooting, Part 3

 

Handling Deadlocks in SQL Server

 

HoldLock和updlock

 

HOLDLOCK 相当于 ISOLATION SERIALIZABLE，在整个事务过程阻塞其他事务的update和delete(仅限同一条数据，不同数据不阻塞)，但不阻塞select

 

 

How does the lock work in sql server? ——by using the lock hash （%%lockres%%）

Another improved functionality in SQL Server 2008 R2

undocumented virtual column  %%lockres%%

Heap Tables and %%lockres%%

 

Key hash value:

http://www.sqlservercentral.com/blogs/practicalsqldba/2013/03/17/sql-server-part-5-explaining-non-clustered-index-on-heap/