Wonderful perspective. Thanks for passing that on.

>> One of the biggest problems here is locking and blocking. In an effort

>> to resolve one possible cause we put the statement below at the top of

>>...

NOLOCK helps with concurrency, but use carefully, like cautioned earlier, especially if you have a lot of explicit transactions that could be rolled back. Don't use NOLOCK to SELECT...