title: How to efficiently delete rows while NOT using Truncate Table in a 500,000+ rows table
body: <p>Let's say we have table <em>Sales</em> with 30 columns and 500,000 rows. I would like to delete 400,000 in the table (those where <code>"toDelete='1'"</code>).</p>
  
  <p>But I have a few constraints :</p>
  
  <ul>
  <li>the table is read / written "often" and I would not like a long "delete" to take a long time and lock the table for too long</li>
  <li>I need to skip the transaction log (like with a <code>TRUNCATE</code>) but while doing a <code>"DELETE ... WHERE..."</code> (I need to put a condition), but haven't found any way to do this...</li>
  </ul>
  
  <p>Any advice would be welcome to transform a </p>
  
  <pre><code>DELETE FROM Sales WHERE toDelete='1'
  </code></pre>
  
  <p>to something more partitioned &amp; possibly transaction log free.</p>