In SQL Server 2005, what is the maximum size of

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

(Continued from previous question...)

In SQL Server 2005, what is the maximum size of an index key?

Answer: 900 bytes
Explanation: The maximum size for SQL Server 2005 is the same as SQL Server 2000; it is 900 bytes. This does not include nonkey columns that are included.

(Continued on next question...)

Other Job Interview Questions

• You wish to configure event logging for your SQL Server 2005 Notification Services instance. Where would you make this change?
• What does the ERROR_PROCEDURE() function return?
• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• You want to release some memory and reduce SQL Server to 3GB or RAM. How can you do this?
• You then write a function to use this assembly, but it does not work. What could be the problem?
• On which platforms can you use Instant File Initialization to improve database growth performance in SQL Server 2005?
• Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
• In SQL Server 2005, what does the CREATE SERVICE command do?
• What is the best way to have your junior DBA do this?
• For regulatory reasons, you must maintain an exact text copy of your XML documents in your SQL Server 2005 database. What datatype of storage should you choose?
• More...