title: High performance data insert into SQL Server
body: <p>I'm inserting about 7 million rows into a table in SQL Server. The table has about 9-10 columns and it has a <code>clustered index</code> on 2 keys (columns) and 3 more <code>unclustered indexes.</code> I'm trying to do high-performance/bulk insert of data, but it gets pretty slow after inserting 3 million records with the disk usage going up to 99%. Here is what I did to speed up this process:</p>
  
  <p>1) Disabled all nonclustered indexes. I didn't disable the 2 column clustered index because data cannot be inserted after the clustered index is disable?</p>
  
  <p>2) I'm using C# <code>SqlBulkCopy</code> to do bulk insert of 5,000 records each time.</p>
  
  <p>3) The table doesn't have any constraints and triggers</p>
  
  <p>Is there anything I should be doing to speed up this data insert process?</p>