title: SQL Server 2008R2: 'DELETE FROM' hangs forever, but 'SELECT' works fine
body: <p>I'm not a DBA by any means, so I'm lost on this one. I have a table with 152,000 rows in it. I'm trying to execute this statement:</p>
  
  <p><code>DELETE FROM FILES WHERE Asset_Id = 340</code></p>
  
  <p>And it hangs forever in the query window -- just says "Executing query...". This statement works fine:</p>
  
  <p><code>SELECT * FROM FILES</code></p>
  
  <p>I also have a copy of the DB  that I tried the delete statement on, and it ran in less than a couple seconds with no issue. So there must be something going on with that table. What could possibly be going on here? It's affecting functionality in my web app.</p>
  
  <p>Thanks.</p>