Manage Partition Wizard (Select Tables for Partition Switching Page)

Switch in
Select to divide the last partition into two partitions. You can then enter a value into the Right boundary column of the last partition. When a value is entered, the left boundary value of the new partition becomes greater than or equal to (>=) the value you entered in the Right boundary column of the last partition.

For example, if the left boundary value of the last partition is 1000 and the right boundary value is "infinity", enter 2000 into the Right boundary column of the last partition.

You will then have two partitions: one partition with a left boundary value of ">= 1000" and a right boundary value of "<2000", and another partition with a Left boundary value of >= 2000 and a right boundary value of "infinity".

Switch out
Selectto choose an existing table to switch out your data to or to enter a name for a new switch-out staging table.

Partition grid
Displays the partition name, Left boundary, Right boundary, Filegroup, and Row count of the partitions you selected.

Switch in table
Select the staging table you want to use to switch in your data. You must create this staging table before you switch partitions with the Manage PartitionsWizard.

Next used filegroup
Select the filegroup for the partition to be switched into.

Switch out table: New
Enter a new name for the staging table you want to use for the partition to switch out of the current source table.

This option is only available if Switch out is selected.

Switch out table: Existing
Select an existing staging table you want to use for the partition you want to switch out of the current source table. If the existing table contains data, this data will be overwritten with the data you are switching out.

This option is only available if Switch out is selected.

Reuse the filegroup of the partition that has been switched out
Select to use the filegroup of the partition that has been switched out for the next-used filegroup.