Return to SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK
SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK
Written by Bill Graziano on 11 October 2000
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!