Maintaining Partitions
Maintaining partitions can be a challenge. Over time, as your data changes and the values of the partition columns change, you may need to add, remove, or migrate partitions. One of the benefits of partitioning is that older partitions can be quickly deleted as necessary, partitions can be moved to slower storage, and partitions can be archived to other tables. In this section, we will see how these actions can be done easily and efficiently.
Adding Partitions
One of the most common tasks that you will perform is adding partitions. As your data grows over time, you will need to increase the number of partitions defined on your partitioned table. You do this by modifying the partition function using the ALTER PARTITION FUNCTION ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
