If you want to apply a hot fix to SQL Server 200

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

(Continued from previous question...)

If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?

Answer: You need to only apply the latest hot fix.

Explanation: Hot fixes are cumulative, so if you want to apply the latest hot fix, it will include all the previous ones.

(Continued on next question...)

Other Job Interview Questions

• In a new default SQL Server 2005 installation, what is the status of the dedicated administrator connection?
• How large a database can you have in this edition of SQL Server 2005? ...
• 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?
• What does the CREATE SERVICE statement do in SQL Server 2005?
• When using the SQLCMD tool, what does the -V parameter do?
• What does the Queue Reader Agent do in SQL Server 2005 replication?
• In SQL Server 2005 Integration Services, if you want to import a flat file very quickly that contains only integer data, what type of parsing should you use?
• What does the DEALLOCATE statement do in SQL Server 2005?
• How many connections are available in SQL Server MSDE 2000?
• How does a differential backup know which extents have changed so that it can be very quickly run?
• More...