SQL Server - Overcoming Lock Waits and Blocking (READPAST)
SQL Server Locking & Blocking
I’m sure all of you who work with SQL Server systems will have experienced the frustration of trying to retrieve a set of records only to find that someone is updating/deleting/inserting one or more records that are matched by your query, and locks prevent you from accessing part or all of your record set.