Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | TastaYak Posting Veteran
 
 
                                        60 Posts | 
                                            
                                            |  Posted - 2014-08-19 : 03:30:33 
 |  
                                            | Hi!I copied my cube from one server to the other with import DB. When I processed my cube on the other server with new data, the size of one partition changed from 1.8G to 12G. When I check the oroginal tables, their sizes are almost the same, and number of rows too. I deleted aggregation and after process the size dropped to 1.3G.What can I check and change to get lower size of my partition (with aggregations, of cause)Thank you for help beforehand |  |  
                                |  |  |  |