title: DROP TABLE or DELETE TABLE? Which is best practice?
body: <p>Working on redesigning some databases in my SQL SERVER 2012 instance.</p>
  
  <p>I have databases where I put my raw data (from vendors) and then I have client databases where I will (based on client name) create a view that only shows data for a specific client.</p>
  
  <p>Because of the this data being volatile (Google Adwords &amp; Google DFA) I typically just delete the last 6 days and insert 7 days everyday from the vendor databases. Doing this gives me comfort in knowing that Google has had time to solidify its data.</p>
  
  <p>The question I am trying to answer is:</p>
  
  <ol>
  1. Instead of using views, would it be better use a 'SELECT INTO' statement and DROP the table everyday in the client database?
  </ol> 
  
  <p>I'm afraid that by automating my process using the 'DROP TABLE' method will not scale well longterm. While testing it myself, it seems that performance is improved because it does not have to scan the entire table for the date range. I've also tested this with an index on the 'date' column and performance still seemed better with the 'DROP TABLE' method.</p>
  
  <p>I am looking for best practices here.</p>
  
  <p>NOTE: This is my first post. So I am not too familiar with how to format correctly. :)</p>