Microsoft® SQL Server 2012 Unleashed

Creating a Partition Scheme

After you create a partition function, the next step is to associate a partition scheme with the partition function. A partition scheme can be associated with only one partition function, but a partition function can be shared across multiple partition schemes.

The core function of a partition scheme is to map the values defined in the partition function to filegroups. When creating the statement for a partition scheme, you need to keep in mind the following:

A single filegroup can be used for all partitions, or a separate filegroup can be used for each individual partition.

Any filegroup referenced in the partition ...