Database Reference
In-Depth Information
selected model. Remember that your development model has a GUID as
part of its name.
There's moreā¦
Partition management is a key part of your model design. What if you wanted to
move the data from the six-month partition into your historical partition? Partitioning
supports merging partitions. To do this, open up
Microsoft SQL Server Manage-
ment Studio
and right-click on the table. Select the
Partitions
option from the con-
text menu, and it will open a dialog that is shown in the following screenshot.
Select the two partitions you want to merge. Once you have them selected, the
Merge icon, which has two arrows pointing at each other, will become activated. Click
on the Merge icon, and the
Merge Partition
dialog will open. Once it is open, you
can see that
Target Partition
is our
Internet Sales - History
partition, and
the selected
Source Partition
option is the
Internet Sales - 6 Months
par-
tition. At this point, if we want to merge more partitions at the same time, we can do
so by selecting the other partitions to merge.
Search WWH ::
Custom Search