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

By Bill Graziano on 11 October 2000 | 0 Comments | 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! Follow the link to SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK...

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

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

Advanced 'Insert Into' (0 Replies)

SELECT DISTINCT but up to 3? (6 Replies)

error 102 on small query (4 Replies)

Eliminatng Records in a Query (2 Replies)

Error sending your message please try again latter (3 Replies)

LEFT() function (5 Replies)

clearing the transactionlog (23 Replies)

Time Field (5 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -