O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required