title: Select with (nolock)
body: <p>My boss keeps on forcing me to write SELECT queries with <code>with (nolock)</code> to prevent deadlocks. But AFAIK, Select statements by default does not have locks, so selecting with <code>with (nolock)</code> and selecting without doesn't make any difference. Please correct me if I am wrong.</p>
  
  <p>The two queries:</p>
  
  <pre><code>SELECT * from EMP with (nolock)
  
  SELECT * from EMP 
  </code></pre>
  
  <p>Isn't both are same. If I don't put nolock will it be prone to deadlocks? Please tell me what should I use.</p>