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:
- the current SELECT statement
- other transactions against the given table
Example:
Select *
from aTable with (NOLOCK)