Articles on Locking

Row Locking ( 13 August 2000 - Bill Graziano

Avoid Locking Conflicts ( 18 September 2000 - Bill Graziano

SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK ( 11 October 2000 - Bill Graziano

Introduction to Locking in SQL Server ( 12 December 2007 - Mladen Prajdić

Application Locks (or Mutexes) in SQL Server 2005 ( 7 January 2008 - Mladen Prajdić