BTW... in anticipation of you using any form of partitioning of one month per file per filegroup, if you think it was easy, you probably did it wrong and wasted a huge amount of space per file. If you decide to go the route of partitioning of the base data (regardless of the use of a summary table or not), let us know... I have some tricks that I've used when I've had to partition such mostly-static tables.