Anyone know any good articles relating to data archive strategies?
Lets say that you have two tables.
Invoice_Header, Invoice_Items
In the past, what I've done is to create two more tables like:
Invoice_header_archive and invoice_items_archive
and copy the records out of the "current" tables and into the archive tables. This serves the purpose of reducing the size of the current tables and consequently improving performance.
This is (obviously) an over-simplified version, but I was curious what others do for data archiving where you want to keep the data accessible.
Brandon Harker
Sebae Data Solutions