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.
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 based on the ...
Get Microsoft® SQL Server® 2012 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
