Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server.

This story continues at http://www.databasejournal.com/news/article.php/3679266