To optimize the configuration of tempdb for perf

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

(Continued from previous question...)

To optimize the configuration of tempdb for performance, what setting should be used for the tempdb recovery model?

Answer: Simple

Explanation: Since tempdb is used for temporary storage and rebuilt every time the server is started, the Simple recovery mode makes the most sense.

(Continued on next question...)

Other Job Interview Questions

• Which of the following services is instance-aware?
• What value should you use for the BROKER_INSTANCE parameter?
• Where are Notification Services event messages logged in SQL Server 2005?
• What is a zettabyte?
• Which index rebuild operation in SQL Server 2005 can be performed online?
• When creating a full-text index on a BLOB column ...
• Where can you view the list of server-scoped DDL triggers?
• A certificate is like which type of key in SQL Server 2005 encryption?
• Which type of XML variable requires a\one and only one root element?
• You then write a function to use this assembly, but it does not work. What could be the problem?
• More...