Microsoft® SQL Server® 2012 Step by Step

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.

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 ...