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/