title: Why would this SELECT statement lock up on SQL Server?
body: <p>I have a simple query like this</p>
  
  <pre><code>SELECT * FROM MY_TABLE;
  </code></pre>
  
  <p>When I run it, SQL Server Management Studio hangs.</p>
  
  <p>Other tables and views are working fine.</p>
  
  <p>What can cause this?  I've had locks while running UPDATE statements before, and I know how to approach those.  But what could cause a SELECT to lock?</p>
  
  <p>I have run the "All Blocking Transactions" report, and it says there are none.</p>