Home Forums SQL Server 7,2000 Performance Tuning Using 'WITH(NOLOCK) to Improve Performance. RE: Using 'WITH(NOLOCK) to Improve Performance.

  • June 9, 2003 at 7:22 am

    #460348

    I don't think the hint hurts you. Easy enough to test a few times with/without. Probably need to revisit the query plan, see what can be tweaked.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter