Current SQL limits

Last Post 31 Dec 2005 02:06 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
PaulMcKibben
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.
SQLUSA
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
http://www.sqlusa.com/freetrial2005/
SQL Server 2005 Training
You are not authorized to post a reply.

Acceptable Use Policy