O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

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

Managing Partitions

Once a table or index is partitioned, SQL Server will automatically store the data according to the definition of your partition function and partition scheme. Over time, the partitioning needs of your data will change.

SPLIT and MERGE Operators

With data constantly changing, partitions are rarely static. Two operators are available to manage the boundary point definitions—SPLIT and MERGE.

The SPLIT operator introduces a new boundary point into a partition function. MERGE eliminates a boundary point from a partition function. The general syntax is as follows:

ALTER PARTITION FUNCTION partition_function_name()
{SPLIT RANGE ( boundary_value )
  | MERGE RANGE  ( boundary_value ) } [ ; ]

You must be very careful when using the SPLIT and ...

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