What is the scale of measurement for the cost th

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

(Continued from previous question...)

What is the scale of measurement for the cost threshold for parallelism setting in SQL Server 2005?

Answer
Seconds

Explanation
This value measures the number of seconds for a plan where the optimizer chooses between serial and parallel plans.

(Continued on next question...)

Other Job Interview Questions

• Which key does the OPEN MASTER KEY statement open?
• You want to be sure that your Scalable Shared Database is as available as possible. Which of the following is not needed for this?
• What's the difference between a server login and a database user?
• Which of the following columns can be indexed with SQL Server 2005 Full-Text Search?
• What format are images rendered in if they were stored originally in another format?
• Report Builder has no built in support for source control. Which of the following choices could be implemented if you decided that those reports needed to be under source control?
• Your SQL Server 2005 Express Edition locks up frequently and cannot be accessed. How can you enable the dedicated administrator connection?
• To maintain the best performance of your SQL Server 2005 databases, how should you deploy encryption technologies?
• You cannot execute procedures on the 2005 server. Why not?
• What is a zettabyte?
• More...