It seems there is some interests in table partitioning.
Read these if you need more motivation:
- Table partitioning case study (impressive numbers)The data architecture easily scaled out 300 percent to support a 600 percent increase in customers. Server responsiveness became twice as fast, producing sub-second response times. Uptime rose to a virtually continuous 99.999 percent. And, helping to keep costs low, the productivity of database administrators rose by 400 percent.
- Webtrend – 1000 partitions
- SQLCAT team: TOP 10 best practices for large database warehouse (count how many best practices are related to table partitioning)
Now you’re ready and would like to learn more– read these:
- Partitioned Tables and Indexes in SQL Server 2005
- Partitioned Table and Index Strategies Using SQL Server 2008
- Loading Bulk Data into a Partitioned Table
- Support for 15,000 Partitions in SQL Server 2008
- Strategies for Partitioning Relational Data Warehouses in Microsoft SQL Server
- Clarifying left and right in the definition of a partition function in SQL Server 2005
Go crazy and good luck!