Current SQL limits

Last Post 31 Dec 2005 02:06 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

15 Apr 2004 12:46 PM
I would like to know what is being done with the 64,000 "item" limit in dimensions. Also if the Analysis Services security window is being enhanced to scroll. I have a SQL 2000 dimension that I cannot apply custom security against because the number of items exceed what is displayable in the window.
New Member
New Member

31 Dec 2005 02:06 AM
I hit that limit for the Zipcode dimension. There are 77K zipcodes.

It is a problem. It forces data warehouse architects to scale back dimension to the popular values.

Kalman Toth, SQL Guru
SQL Server 2005 Training

Acceptable Use Policy