I currently have a dataset that has 2 years worth of data.  I would like to reduce this to a rolling 30 days,  every day I would remove 1 day and store else where and add another day.  I need to do this so processing time is reduced and to save space.  I will be zipping the data that is removed and storing on a separate server. Current size of the table with 2 years data is 29GB and each day I am adding  200k lines of data with 100 columns.  I would like to know the quickest way to remove the oldest date and insert the data so I only have 30 days worth of data in the table.  ... View more