SQL Server® 2008 Administration: Instant Reference

6.1. Manage SQL Server Locks

SQL Server uses locks to prevent conflicts from multiple operations that are using the same resources. Some concurrent interactions are acceptable. For example, there is no problem if two users are reading the same data from a table at the same time. However, two different users trying to modify the same data at the same time would be a real problem.

6.1.1. Identify Lock Types and Behaviors

Locks in SQL Server are categorized in two different ways. First, locks can be classified based on the objects they affect, such as a data row, a data page, or an entire table. Second, they can be classified by their behavior, such as a shared lock or an exclusive lock. Understanding the different types of locks and how they ...