i'm waiting the part VI, hope that will be partition table and index .
I'm a database admin in a a large telco industry in senegal and I want to organize my CDR( call data record) by monthly table within it il wish to create file group by month and also i want to partition the table by day and affect the partition of a day of week to their corresponding filegroup
SQL Server 2005 introduced the ability to partition a large relation into smaller logical chunks to improve the administration and management of large tables. It has also been used successfully to improve query processing, especially when it comes to large decision-support applications. Further SQL Serve 2008 has enhanced this feature with partitioned table parallelism (PTP) feature.