SQL Server needs to be able to manage data with many different transactions happening that are reading, updating, inserting, and deleting. Whenever SQL looks at data, it needs to put a lock on the record or object to maintain data integrity and allow stable “concurrency” while the database is being used. There are several different locks that can be put on several fundamental different objects within SQL Server. Let’s look at them.
by Nick Adams