Home Forums SQL Server 2008 T-SQL (SS2K8) Question about query hint nolock RE: Question about query hint nolock

  • April 13, 2013 at 5:10 am

    #1606240

    GilaMonster (4/13/2013)

    ReadPast = skip locked rows. Also rather bad for accurate results. Find for stuff like dashboards or areas where close to accurate is good enough

    If you're having problems with blocking, I recommend tuning queries as a first step and one of the snapshot isolation levels as the second step if still necessary.

    Thank you twice.

    I will read that link and try to talk about nolock issues in my company

    I hope I 'd get convict them.

    Best regards