SQL Server 2005/2008 Lock Escalations

SQL Server 2008/2005 Concurrency control with locks