Lock Scenarios Using sys.dm_tran_locks

Learn about the impact of locking and blocking in sessions through some demonstrations of different types of actions.

SELECT Queries and Type of Locking

Transaction Locking and Row Versioning Guide

This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.

Lock Owner Blocks

Prevent multiple users from running the same SQL Server stored procedure at the same time

There is a stored procedure that must be run by only one user at a time. In this tip, learn how to prevent multiple users from running the stored procedure at the same time.

Locking, Blocking and Deadlocking

Introduction into Locking, Blocking and Deadlocks in SQL Server, and why SQL Server uses these actions.

Lock mode RangeI-N

Lock Escalation Limit

Use of Identity Property to Resolve Concurrency Issues

This article describes how the identity property was used to resolve contention in a database

LOCK