Database Reference
In-Depth Information
7. As the screenshot shows, the final wizard screen allows building aggrega-
tions immediately, copying aggregation designs from an existing partition or
designing aggregations later. You will learn about aggregations later in this
chapter; for now choose the design aggregations later option. Designing
aggregations later also allows us to check the Deploy and Process Now
box. Once you click on Finish , SSDT will proceed with deploying changes,
and you'll have the option to process the newly created partition.
Creating partitions through AMO
If you have a relatively small database with a handful of partitions, using XMLA state-
ments through SSMS or running through a wizard several times a year will suffice. In
an enterprise environment, partition management must be automated because run-
Search WWH ::




Custom Search