Locking and Blocking
In SQL Server, locking and blocking are mechanisms that are used to protect data integrity and consistency by controlling access to data by concurrent transactions. Locking is the process of identifying and reserving data resources for use by a specific …