title: SQL Server - insert/select slow after TRUNCATE TABLE has 6 over million rows
body: <p>Seeing slowness in insert/select after truncating a table that has over 6 million rows.</p>
  
  <p>I daily insert 5 to 6 millions records into a table and I was able to insert/select data without any issue for some 7 or 8 days but when the table size went above 10 GB / 30 million rows, there were a few timeout issues. </p>
  
  <p>So I thought of truncating the table daily before data uploading since 1 day's data is enough for me. Now I am seeing extreme slowness in insert/select till i rebuild index in middle of upload. last 2 days it took 5 hours to insert 1 million rows , after a index rebuild remaining 3.5 to 4 million rows went into table in less than 15 mins. I dont prefer to rebuild index in middle of my upload process.</p>
  
  <p>i don't do a .NET Bulk insert , i insert rows in batches using Stored proc , since i do some validation.</p>
  
  <p>I am using SQL Server 2008.</p>