What is the maximum number of instances of Analy

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

(Continued from previous question...)

What is the maximum number of instances of Analysis Services 2005 can be installed on a server?

Answer: 50

Explanation: SQL Server 2005 supports a maximum number of 50 instances per server. For some editions of SQL Server, the number is less.

(Continued on next question...)

Other Job Interview Questions

• Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database: Submitted by Charles Hawkins
• Can you use Full-text search to index this column?
• Which is larger in size in SQL Server 2005 if you are using symmetric keys?
• If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?
• What is the easiest way to capture the SQL statement for a Report Builder report you're troubleshooting?
• The Sort component in SQL Server 2005 Integration Services is what type of component?
• To which versions of SQL Server 2005 can you upgrade an SQL Server 2000 MSDE SP3 edition database?
• What is the best way to have your junior DBA do this?
• Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL trigger assigned to it?
• You want to partition these past orders columns into a new table. What type of partitioning is this?
• More...