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

Parallel Processing

Satish More brings us a framework that you can use to execute a number of jobs in parallel and finish a task quickly.

Retrieve locking block-chain

This script utilize the DMV to quickly build the locking block-chain.

Optimistic Locking in SQL Server using the ROWVERSION Data Type

Using the default SQL Server READ COMMITTED isolation level, my application sometimes falls victim to the dreaded "lost update" condition where two of my users edit the same row for update but the user who submits his/her change last overwrites changes made by the other user. Is there a good way to check for this and prevent it?