Lock Compatibility
http://msdn2.microsoft.com/en-us/library/aa213041(SQL.80).aspx.
Locking Hints
http://msdn2.microsoft.com/en-us/library/ms189857.aspx
Table Hint (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms187373.aspx.
Using Snapshot Isolation
http://msdn2.microsoft.com/en-us/library/tcbchxcb.aspx
"The Rational Guide to SQL Server 2005 Service Broker" by Roger Wolter (Rational Press, 2006)