I guess the real question is:

If I don’t care about dirty reads, will adding the with (NOLOCK) hint to a SELECT statement affect the performance of:

  1. the current SELECT statement
  2. other transactions against the given table

Example:

Select * 
from aTable with (NOLOCK)

5 Answers
5

Leave a Reply

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