title: Recommended way of adding daily data to database
body: <p>I receive new data files every day.  Right now, I'm building the database with all the required tables to import the data and perform the required calculations.</p>
  
  <p>Should I just append each new day's data to my current tables?  Each file contains a date column, which would allow for a "WHERE" query in the future if I need to analyze data for one particular day.  Or should I be creating a new set of tables for every day?</p>
  
  <p>I'm new to database design (coming from Excel).  I will be using SQL Server for this.</p>