Nibbling Deletes
Video References
These additional references will help you take what you've learned in this SQL Server Video to the next step.
Book References
Inside Microsoft SQL Server 2005: The Storage Engine
Relevance: Chapter 8 provides an excellent overview of SQL Server Locking internals, and provides detailed information on how locks are acquired and escalated - along with details on lock compatibility and interactions.
Inside Microsoft SQL Server 2000
Relevance: Chapter 9 provides specific details on how data is modified within SQL Server, and chapter 14 provides excellent information on locks, lock escalation, and lock compatibility.
Links / References
SQLAdvice.com [link]
Relevance: For more information on Nibbling Deletes, check out a blog post I did a while back on how they work and how to use them.
SQL Server Books Online [link]
Relevance: The following T-SQL References from Books Online can help shed additional light on the topics covered in this video:
SET ROWCOUNT (SQL Server 2000 Only):
SQL Server 2000
TOP:
SQL Server 2005
SQL Server 2008
WAITFOR:
SQL Server 2000
SQL Server 2005
SQL Server 2008
