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 7:57 am

    #1816132

    Brandie Tarvin (7/30/2015)

    GilaMonster (7/30/2015)

    Luis Cazares (7/30/2015)

    NOLOCK hints can be useful to get estimates of certain data.

    Yup. In fact I told some people recently to put nolock onto a bunch of queries. They were populating a dashboard showing number of documents captured, number of claims processed, number of errors encountered etc. The queries were causing blocking and it doesn't matter if they're not 100% accurate.

    So would the SNAPSHOT isolation level not have worked in this instance?

    For me, it would be an overkill.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2