How to put NO LOCK for stored procedure T-SQL for all tables
You can set this at the query level:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
Like NOLOCK, this allows for dirty reads.
If dirty reads are a problem you may look into using 'Isolation level Snapshot': this creates a regular snapschot of your database and uses that for calculation. Downside is that this copy requires extra memory.