September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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 scheme must exist before the partition scheme is created.
• There must be enough filegroups referenced ...