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

  • August 2, 2013 at 6:35 am

    #1638136

    Phil Parkin (8/2/2013)

    If you can guarantee that the database is and will be in a fully committed and unchanging state when the proc runs (eg if everything is in read-only mode)

    And if the DB is guaranteed to be essentially read-only at the time, then there's no real point in read uncommitted as there will be no exclusive locks that could block the report.

    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