Home Forums SQL Server 2005 T-SQL (SS2K5) SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED VS WITH(NOLOCK) RE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED VS WITH(NOLOCK)

  • October 27, 2008 at 3:37 pm

    #890298

    DBA (10/27/2008)

    hi guys i have found several stored procedures in which i see both of this, for what i know only one is needed to read dirty reads and don't cause blocks is that correct? can i eliminate one? if so which one is faster for performance? thanks in advance.

    Yup. They are identical in meaning and in effect.

    Better yet, remove both and remove the chance for dirty reads, dupe reads, etc.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass