Database Reference
In-Depth Information
Click on OK , and the partitions will be merged. The Partitions dialog will now only
show two partitions. From here, you can also process the new partition to complete
the process.
Note
If you deploy the model to the server using SSDT and have not merged the par-
titions in the same way, the partition design in SSDT will overwrite any changes
made in Microsoft SQL Server Management Studio .
See also
• Partitions can be created using XMLA and PowerShell as well. The recipe on
XMLA discusses how to script processes using SSMS. Refer to the recipe on
creating multidimensional partitions for more details on using PowerShell to
create partitions with XMLA.
Search WWH ::




Custom Search