• rocks (1/8/2013)


    yes users understand these type of dirty read might happen.

    I doubt they fully understand what dirty read really means otherwise they would not be alright with it. It means their reports are generally useless. If you care about the data you would be best to look into enabling READ_COMMITTED_SNAPSHOT in the database. The nice thing is that no queries need to change, not even the ones with the NOLOCK hint applied, and you'll automatically get transactionally consistent reads. The downside is that it can add some workload onto tempdb, but typically it is an easy tradeoff and unless your system is tempdb-constrained at the moment one that usually has no overall adverse effects.

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