DBA > Job Interview Questions > Microsoft SQL Server FAQs

How many dimensions can you have in a SQL Server

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How many dimensions can you have in a SQL Server 2005 Analysis Services database?

Answer: 2,147,483,647

Explanation: The maximum number of dimensions in a SQL Server 2005 Analysis Services database is 231-1, or 2,147,483,647.

(Continued on next question...)

Other Job Interview Questions