Solved

How many partitions can be created  in cube ?

Posted on 2010-08-12
2
585 Views
Last Modified: 2013-11-16
How many partitions can be created  in cube ?Is there any limit?
I am using SQL 2008 Analaysis Services.
Thanks
0
Comment
Question by:venk_r
2 Comments
 
LVL 18

Accepted Solution

by:
Matthew Kelly earned 125 total points
ID: 33426175

Essentially, unlimited partitions: http://searchsqlserver.techtarget.com/tip/Creating-and-managing-SQL-Server-Analysis-Services-partitions

"SQL Server Analysis Services has an upper limit on the number of partitions -- 2^31-1 = 2,147,483,647 -- but cubes that have this many partitions are rare. Don't be afraid to create as many partitions as needed."

0
 
LVL 8

Author Closing Comment

by:venk_r
ID: 33563621
THANKS
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now