http://blogs.technet.com/josebda/archive/2009/03/19/sql-server-2008-locking.aspxHere are some notes on "SQL Server 2008 Locking" I took while attending an advanced class on SQL Server taught by Kimberly Tripp ( http://sqlskills.com/AboutKimberlyLTripp.asp ). Please note that, although these notes were taken during the class, I mighten-USCommunityServer 2.1 SP1 (Build: 61025.2)