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)

  • December 19, 2008 at 6:52 am

    #915217

    Swirl80 (12/19/2008)

    out of curiosity, from a performance point of view, which is better:

    As I said above, they are identical in meaning and in effect.

    Neither is desired for performance reasons. If there's blocking problems the best thing to do is fix the cause, not hide they symptoms.

    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