Locking and Blocking

Learn about SQL Server Locking and Blocking from these valuable tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.

Title Author Date
SQL Server NOLOCK Anomalies, Issues and Inconsistencies Aaron Bertrand2026-06-13
Understanding the SQL Server NOLOCK hint Greg Robidoux2026-05-14
SQL Bulk Insert with TABLOCK Performance Considerations Mehdi Ghapanvari2026-05-09
Reduce SQL Server Deadlocks with a Clustered Index Jared Westover2025-07-16
SQL Server UPDATE lock and UPDLOCK Table Hints Sergey Gigoyan2025-06-19
How to identify blocking in SQL Server Nitansh Agarwal2025-05-27
Processing Data Queues in SQL Server with READPAST and UPDLOCK MSSQL Tips2025-04-20
Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT Jared Westover2024-07-18
SQL Server Locking, Data Modification and Committing Data Rakesh Patil2023-10-13
Troubleshoot SQL Server Blocking and Resolving with NOLOCK Jan Potgieter2023-09-05
SQL Server Deadlock Troubleshooting in Stored Procedures Chandra Rawat2023-05-30
Identify SQL Server Locking and Blocking for Rows, Tables and Objects Eric Blinn2023-05-15
SQL Deadlock Priority to Control Transaction Roll Backs Sergey Gigoyan2022-11-30
SQL NOLOCK Code in SQL Server DML Statements Aaron Bertrand2021-09-01
Eliminate False Positive SQL NOLOCK patterns in SQL Server – Part 3 Aaron Bertrand2021-08-18
Finding problematic SQL NOLOCK patterns for UPDATE and DELETE Aaron Bertrand2021-08-03
Find SQL NOLOCK Problematic Patterns Aaron Bertrand2021-07-28
Monitor Deadlocks in SQL Server with system_health Extended Events Sergey Gigoyan2020-05-27
Prevent SQL Server Blocking using Lock_Timeout Bhavesh Patel2020-01-07
Index Reorganize and Update Stats Causing SQL Server Blocking Ben Snaidero2019-01-17
Configuring Extended Events to find Locking Issues in SQL Server Alejandro Cobar2018-10-31
Monitoring SQL Server Blocked Sessions with SQLCMD Daniel Farina2017-12-11
Does updating SQL Server statistics cause blocking Daniel Farina2016-12-16
Find Blocking Processes Using SQL Server Profiler Ben Snaidero2016-09-27
Compare SQL Server NOLOCK and READPAST Table Hints Sergey Gigoyan2016-09-22
Compare Repeatable Read and Serializable SQL Server Transaction Isolation Levels Sergey Gigoyan2016-09-01
Altering lock escalation for SQL Server tables Eli Leiba2016-07-28
How to Kill a Blocking Negative SPID in SQL Server Ahmad Yaseen2016-01-18
Detect and Automatically Kill Low Priority Blocking Sessions in SQL Server Jeffrey Yao2014-07-16
Prevent multiple users running the same SQL Server Stored Procedure Andy Novick2014-04-10
Implement SQL Server Transaction Retry Logic for failed transactions Daniel Farina2014-03-25
Avoid using NOLOCK on SQL Server UPDATE and DELETE statements Aaron Bertrand2014-02-24
Explanation of SQL Server IO and Latches Derek Colley2013-10-30
Demonstrations of Transaction Isolation Levels in SQL Server Derek Colley2013-06-18
Identify the cause of SQL Server blocking Basit Farooq2013-04-18
Using a Clustered Index to Solve a SQL Server Deadlock Issue Ben Snaidero2011-10-28
Understanding SQL Server Blocking Tim Ford2010-04-06
Understanding SQL Server Locking Tim Ford2010-03-23
Execute SQL Server SELECT command without locking Jeremy Kadlec2008-12-15
Optimistic Locking in SQL Server using the ROWVERSION Data Type MSSQL Tips2008-05-19
Using SQL Server Indexes to Bypass Locks Tal Olier2008-04-25
Capturing SQL Server Deadlock Information in XML Format Jeremy Kadlec2007-04-30
SQL Server Profiler Graphical Deadlock Chain Jeremy Kadlec2007-04-13
SQL Server Deadlock Priority Configuration Jeremy Kadlec2007-03-27
Finding and troubleshooting SQL Server deadlocks Greg Robidoux2006-08-09