Thanks for the quick response, Paul. There are about 150 clients and 200 weeks. That's about 30,000 client/date combinations being created if I were to partition on date...

Thanks for the quick response, Paul.

I'm going to cap the number of partitions to 500 and archive anything over to a historical archive table. The main thing bothering me...