I'm supporting a couple of applications that have an active data set and a history data set in the same SQL database. The table structures for each set are identical. What is the best way to move the completed records to history at the monthly close? There could be 25K records to archive in the largest tables. Some tables have multiple indices.