title: Effect of NOLOCK hint in SELECT statements
body: <p>I guess the real question is:  </p>
  
  <p>If I don't care about dirty reads, will adding the <strong>with (NOLOCK)</strong> hint to a SELECT statement affect the performance of:</p>
  
  <ol>
  <li>the current SELECT statement  </li>
  <li>other transactions against the given table</li>
  </ol>
  
  <p>Example:</p>
  
  <pre><code>Select * 
  from aTable with (NOLOCK)
  </code></pre>