title: Removing CONSTRAINT in SQL takes too long
body: <p>I'm running the query below on SQL Server 2008 R2 to disable a constraint to be able to do some modifications</p>
  
  <pre><code>ALTER TABLE mytable NOCHECK CONSTRAINT UCxxxx
  </code></pre>
  
  <p>and it's been 50 minutes and still running.</p>
  
  <p>Table has about 2 million rows... </p>
  
  <p>Any ideas?</p>