title: Deleting 1 millions rows in SQL Server
body: <p>I am working on a client's database and there is about 1 million rows that need to be deleted due to a bug in the software. Is there an efficient way to delete them besides:</p>
  
  <pre><code>DELETE FROM table_1 where condition1 = 'value' ?
  </code></pre>