How Do You Create A SQL Server 2005 Partitioned Table?
A new feature introduced with SQL Server 2005 is called partitioning. This allows you to horizontally partition data in your table and decide which filegroups to place each row into. Create your partitioning functions. — All values before 1/1/2006 go in first partition and all values on or after 1/1/2006 go in second create partition function MyPF(datetime) as range right for values (‘20060101′) Create filegroups that will contain our partitioned values alter database X add filegroup FG1 alter database X add filegroup FG2 Add files to the filegroups created in step 2. alter database X add file (name=’File1′, filename=’C:\MSSQL\Data\X1.ndf’) to filegroup FG1 alter database X add file (name=’File2′, filename=’C:\MSSQL\Data\X2.ndf’) to filegroup FG2 Create a Partitioning Scheme. This associates the partitioning function created in Step 1 with the filegroups created in Step 2 and 3. create partition scheme MyPS as partition MyPF to (FG1, FG2) Create a table that makes use of the Partition
