What is the cost threshhold for parallelism in S

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

(Continued from previous question...)

What is the cost threshhold for parallelism in SQL Server 2005?

Answer
This is the number of seconds that a serialplan cannot exceed if it is to be used. A parallel plan is used if the estimate exceeds this value.

Explanation
This is the threshold at which SQL Server determines whether a serial or parallel plan is to be used. When SQL Server calculates that a serial plan exceeds the threshold, it will elect to use a parallel plan instead.

(Continued on next question...)

Other Job Interview Questions

• What's an allocation unit?
• If you run this, what does it return? select applock_mode('public', 'SalesApp', 'Transaction')
• Can a contained in SQL Server 2005 Integration Services enlist in a transaction started by a sibling container?
• What is an example of hardware partitioning?
• Which of the following is an invalid file name for a database file?
• What feature of SQL Server 2005 would help you get the snapshot transferred?
• 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?
• The nesting level for stored procedures in SQL Server 2005, but how many databases can you access inside one stored procedure?
• A certificate is like which type of key in SQL Server 2005 encryption?
• Which of these is not a parameter you can pass to the LOGINPROPERTY function?
• More...