SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK

By Bill Graziano on 11 October 2000 | Tags: Locking

This must-read article, by Michael Balloni, discusses how SQL server locks tables and rows when UPDATE statements or SELECT statements occur. In a heavily hammered database, these locks can lead to slow performance and database errors. Michael also discusses two query-level locking options - NOLOCK and ROWLOCK - that can be used to give SQL Server some hints on how to deal with locking... which can dramatically increase your database's performance! A must read for those who run data-driven Web sites!

Link: SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK

Related Articles

Application Locks (or Mutexes) in SQL Server 2005 (7 January 2008)

Introduction to Locking in SQL Server (12 December 2007)

Avoid Locking Conflicts (18 September 2000)

Row Locking (13 August 2000)

Other Recent Forum Posts

SQL Server 2019 CU vs GDR update which one is correct? (22h)

Need To Generate Shift Rotation Weekwise Rather 7 Day Wise For The Yearmonth 202508 (33d)

Improving update statistics process for 6 big tables (42d)

Peer to Peer Replication is not working between 2 different machines (42d)

SQL HELP in SSMS: The query references an object that is not supported in distributed processing mode (77d)

Subscription sends report with data to one user but empty report to other users (79d)

Pivot Tables in SQL (86d)

Can't restore backup; SSMS says my user account directory is empty (87d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site