If this is going to be a regular thing, have you considered partitioning?Quote:
Originally posted by aj_usa
yes, We have archived and deleted 50% + of the data in some of these tables and would like to shrink their size to verify any performance gain.