Did you look into table partitioning?
>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.
--sb--