Database Reference
In-Depth Information
Perform the following steps for creating partitions through wizards:
1. To activate the Partition wizard in SSDT, you can click on the New Partition
link under any measure group on the partitions tab. To activate the same wiz-
ard in SSMS, right-click on the Partitions folder of a measure group and
select New Partition . The wizard works the same way using either of the
tools; since we already have SSDT open, let's continue working within SSDT.
2. After the welcome screen, the wizard asks you to choose the fact table to
be used as the partition source. Note that you can choose the data source
which contains the table. Had we not bound the original partition to a query
Search WWH ::




Custom Search