Why I Love NOLOCK Hints In SQL Server (Video Edition)

Oh, Just Do it.


Going Further


If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly.



4 thoughts on “Why I Love NOLOCK Hints In SQL Server (Video Edition)

  1. Interwebs Quote of the Day: “no one listens to you until they’re paying you”. Preach it, Brother Erik!

    True story. A company I worked at paid a vendor over 20K for a report of performance suggestions. They basically added a few screen shots on the report I gave them.

    When I brought it up I was told that the upper damagement will listen to the vendor because they paid for it. I quickly checked my online bank account and verified I was still getting paid. It was pretty scary for a minute or so. I still get douche chills thinking about it.

    1. HAHAHA, yeah, that’s the funny thing out here in consultant land. Of course, some people pay me for advice and then don’t follow any of it, and pay me again for the same advice.

      Not that I mind.

  2. I see “no lock” being blindly added to every query at my workplace, reason being best practice 🙂
    And several other such things, async calls for sync operations being made all over the place, it is ridiculously bad

Leave a Reply

Your email address will not be published. Required fields are marked *