title: Understanding SQL Server LOCKS on SELECT queries
body: <p>I'm wondering what is the benefit to use <code>SELECT WITH (NOLOCK)</code> on a table if the only other queries affecting that table are <code>SELECT</code> queries.</p>
  
  <p>How is that handled by SQL Server? Would a <code>SELECT</code> query block another <code>SELECT</code> query?</p>
  
  <p>I'm using SQL Server 2012 and a Linq-to-SQL <code>DataContext</code>.</p>
  
  <p>(EDIT) </p>
  
  <p>About performance : </p>
  
  <ul>
  <li>Would a 2nd <code>SELECT</code> have to wait for a 1st <code>SELECT</code> to finish if using a locked <code>SELECT</code>?</li>
  <li>Versus a <code>SELECT WITH (NOLOCK)</code>?</li>
  </ul>