• You really need to read about NOLOCK and what it really does.  Here's a quick article by Denny Cherry, SQL Server MVP, former MCM.
    It's not what you think. It basically allows dirty reads - like using READ UNCOMMITTED in your queries. Which is more important to you, speed or accuracy?

    Maybe you should read Grant Fritchey's book on Execution Plans