title: Adding and deleting millions of records daily
body: <p>Using SQL Server 2008 R2 Web Edition.  My table has 30 days worth of data.  Each day consists of 12 million records.  Each day, I need to import 12 million new records and delete the 12 million oldest records.  The table has two indexes and no keys. I am using BCP to import the new data.  This takes between .5 and 2.5 hours to run.  I am deleting in batches.  The delete takes 20+ hours.  Dropping and recreating indexes did not seem to help.  What is the fastest solution?</p>
  
  <pre><code>    col1 varchar(10)
      col2 varchar(10)
      col3 int
      col4 date
  
      index1 (col1, col2, col4)
      index2 (col4)
  </code></pre>