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

Inside Microsoft SQL Server 2005: The Storage Engine
Review

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

Inside Microsoft SQL Server 2000
Review

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


spacer