Locks in SQL Server

Locking Locking is mechanism of Database Engine to synchronize access by multiple users to the same  piece of data at the same time. Before reading / modifying a piece of data, a transaction must protect itself from the effects of another transaction modifying the same data. The transaction does this by requesting a lock on a piece … Continue reading Locks in SQL Server