SQL Server uses locks to maintain data integrity for reads as well as writes and allows only one process to have control of the data at a time. Different types of locks such as Shared, Update, Exclusive, and Intent are used by the SQL server where each lock has different behavior and effect on data. […]

Read More