Chapter 8. Table partitioning

After completing this chapter, you will be able to

  • Understand table partitioning.

  • Create a partition function.

  • Create a partition scheme.

  • Partition a table.

The concept of partitioning is not very difficult to explain or comprehend. For example, assume you have a table that contains sales data, and you would like to divide the data into segments based on the year of sale. Logically, the table would resemble Figure 8-1.

Logical table partitioning.
Figure 8-1. Logical table partitioning.

As shown in Figure 8-1, dividing the data by year is simple to illustrate. When data is added to the table, it will be placed in the appropriate location ...

Get Microsoft® SQL Server® 2012 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.