Home Forums SQLServerCentral.com Anything that is NOT about SQL! Are the posted questions getting worse? RE: Are the posted questions getting worse?

  • July 30, 2015 at 5:14 am

    #1816069

    Brandie Tarvin (7/30/2015)

    EDIT: Seriously, can anyone give me a real reason why WITH (NOLOCK) might be functionally necessary for production code?

    Incompetent developers.

    Prior to SQL 2005 there might have been. Since SQL 2005, severe reader-writer blocking problems can likely be fixed with READ COMMITTED SNAPSHOT/SNAPSHOT rather than READ UNCOMMITTED.

    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