Create SQL Server Analysis Services Partitions using AMO
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Mon, 19 Nov 2012 07:00:00 UT
Indexed on
2012/11/20
17:13 UTC
Read the original article
Hit count: 272
When you have SSAS cubes with millions of rows of data, it is very helpful to create partitions. If you have a few cubes you could probably do this manually, but if there are many or if you want to automate this process you should look for smarter solutions such as programming the creation of partitions dynamically.
NEW! Never waste another weekend deploying Deploy SQL Server changes and ASP .NET applications fast, frequently, and without fuss, using Deployment Manager, the new tool from Red Gate. Try it now. |
© SQL Server Central or respective owner