SQL 2005 -
04-23-2006
, 12:15 AM
Where can you find the equivalent limitations for SQL Server 2005?
Item Specification
Dimensions in a database 65,535 maximum, regardless of the number of
cubes or whether dimensions are shared or private
Levels in a database 65,535 maximum
Cubes in a virtual cube 255 maximum
Measures in a cube 1,024 maximum
Measures in a virtual cube 2,048 maximum
Dimensions in a cube 128 maximum
Levels in a cube 256 maximum
Levels in a dimension 64 maximum
Members in a dimension 2^31-1 = 2,147,483,647 maximum
Members (or member groups) per parent 64,000 maximum
For more information about using member groups, see Member Groups.
Calculated members (server defined) in a cube 65,535 maximum
Calculated members in a parent measure in session context 31,743
maximum
Calculated members in a parent measure in query context 31,743
maximum
Calculated members in a parent dimension member in session context 759
maximum
Calculated members in a parent dimension member in query context 759
maximum
Aggregations per partition 65,535 maximum
Cells returned by a query 2^31-1 = 2,147,483,647 cells maximum
Although cubes can be larger than this limit, a query that requests
more than 2^31-1 cells from a cube will fail.
Record size for source database table 64 kilobytes (KB) maximum
Length of object name (except dimension name) 50 characters maximum
when using Analysis Manager
24 characters maximum when using PivotTable® Service
Length of dimension name 24 characters maximum
Length of aggregation prefix 50 characters maximum
Maximum number of distinct states in a data mining model attribute
column 255, after which the column becomes MODEL_EXISTENCE_ONLY
For more information, see Data Mining Columns |