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