• I have to agree with colin here. This is one of those "dangerous" articles that could mislead people. You need to think really twice before using (NOLOCK) I would add that a hint is just that "a hint" not 100% of the time you will get what you asked for

    Also it maybe safer to use READPAST instead of NOLOCK as the first option.

    There are scenarios where it fits the bill but that should have been ( in my opinion ) the message that this article should have proposed.

    Just My $0.02


    * Noel