Adding (Nolock) to all select statements in long running SSRS reports?

Question

We have over 500 SSRS reports, is there a way to add all missing (nolock) in the select statements of each dataset by writing a TSQL script? Thanks.

Answer 1

I assume you have investigated and optimised the queries as far as reasonably possible.... If you are not worried about getting the up to the seconds live data (maybe your data is updated infrequently) then you could make the job simpler by add SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED at the top of the query. It's not the most elegant solution but for me, when the data I am reporting on is only updated overnight, it speeds things up considerably.