title: Truncate or Drop and Create Table
body: <p>I have this table in a SQL Server 2008 R2 instance which I have a scheduled process that runs nightly against it. The table can have upward to 500K records in it at any one time. After processing this table I need to remove all rows from it so I am wondering which of the following methods would produce the least overhead (ie Excessive Transaction Log entries):</p>
  
  <ol>
  <li>Truncate Table</li>
  <li>Drop and recreate the table</li>
  </ol>
  
  <p>Deleting the contents of the table is out due to time and extra Transaction log entries it makes.</p>
  
  <p>The consensus seems to be Truncation, Thanks everyone!</p>