• I know this is not an answer to the question you've actually asked, but if your report is required to be accurate, remove the NOLOCK hints.

    They're not a magic 'go faster' stripe, they're actually quite a dangerous option which can lead to queries completely missing data, reading it multiple times and, effectively returning garbage.

    http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.