• You would enable READ_COMMITTED_SNAPSHOT on the database and remove all NOLOCK hints from your queries. See the article I linked to in my initial post on how to enable the option.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato