title: Why use NOLOCK and NOWAIT together?
body: <p>A colleague wrote a query which uses the hints "with (NOLOCK,NOWAIT)".</p>
  
  <p>e.g.</p>
  
  <pre><code>select first_name, last_name, age
  from people with (nolock,nowait)
  </code></pre>
  
  <p>Assumptions: </p>
  
  <p>NOLOCK says "don't worry about any locks at any level, just read the data now"</p>
  
  <p>NOWAIT says "don't wait, just error if the table is locked"
  <br>
  <br>
  <b>Question:</b>
  <br>
  Why use both at the same time? Surely NOWAIT will never be realised, as NOLOCK means it wouldn't wait for locks anyway ... ?</p>