Simulating locking in page level

Through the shared script, you can see the Paglock table hint.

How to Create Deadlocks and Troubleshoot Them

Watch in awe and wonder as Brent Ozar creates a deadlock, then uses sp_BlitzLock after the fact to show you which queries and tables were involved.

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.

Dealing with High Concurrency with Table Hints

Systems with a large number of requests on a critical database table are prone to blocking and slowness. We take a look at getting things done using T-SQL table hints.

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

Large table cleanup with minimal locks

How do you delete millions of rows with minimal impact to the business? This article gives you a way to accomplish the removal of old data.