Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Partitions Rss

   Items 1 to 4 of 4   
 

SQL Server Analysis Services ProcessAdd for a Partition

Is there a way to process only the new data for a partition in SQL Server Analysis Services? Yes, this is accomplished in SQL Server Analysis Services with the ProcessAdd option for partitions. Daniel Calbimonte demonstrates how it works.  Read more...
By Additional Articles 2014/03/27 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,424 reads

Truncate or switch range of a partitioned table

Script to duplicate structure, switch or truncate choosen partitions of a table  Read more...
By Federico Iori 2013/06/03 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 1,139 reads

Truncate or switch range of a partitioned table

Script to duplicate structure, switch or truncate choosen partitions of a table  Read more...
By Federico Iori 2013/06/03 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 1,139 reads

Create SQL Server Analysis Services Partitions using AMO

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.   Read more...
By Additional Articles 2012/11/19 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 2,001 reads
   Items 1 to 4 of 4   
 
Tags
analysis services (ssas) (2)    
amo (1)    
duplicate table (1)    
script (1)    
switch (1)    
truncate (1)