Creating partitioned View in the BAM Archiving Database
Carl Nolan of the UK Solution Development Team wrote an excellent blog post on the above topic. He includes a script for creating partitioned views that can be used if modifications to the existing activity items are continuing to be made.