title: How does using TRUNCATE TABLE affect Indexes
body: <p>Using SQL Server 2005, upgrading to 2012</p>
  
  <p>If I have an ETL the does the following(Simplified)</p>
  
  <pre><code>TRUNCATE TABLE detination
  INSERT INTO detination
  SELECT *
  FROM source
  </code></pre>
  
  <p>Does this clear the index and rebuild it with the inserts? Will I have fragments?</p>