How many Service Packs will be released for SQL

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

(Continued from previous question...)

How many Service Packs will be released for SQL Server 2005 in 2007?

Answer:
Explanation: The answer is up in the air and this is more of a poll than a real QOD. Based on the ways things are going, the staff here sees just 1, though our hope would be that 3 or 4 would be released.

(Continued on next question...)

Other Job Interview Questions

• Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.)
• Can a deterministic computed column be full-text indexed in SQL Server 2005? Submitted by Matija Lah
• What is the Service Broker Identifier
• What does the NULLIF function do?
• You have noticed in both your SQL Server 2000 and 2005 instances that when a database grows in SQL Server, there is a delay in the database response. Why is that?
• When discussing image support in Report Builder, which of the following is the most accurate statement?
• You have just upgraded your server from a single processor by adding 3 additional processors....
• Which collation is used for Service Broker messages sent between the instances?
• You are building a .NET assembly that will access the registry of the local machine for a factor used in a computer column. What permission set should you assign it?
• What does the Queue Reader Agent do in SQL Server 2005 replication?
• More...