You have just upgraded your server from a single

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

(Continued from previous question...)

You have just upgraded your server from a single processor by adding 3 additional processors....

You have just upgraded your server from a single processor by adding 3 additional processors. Your settings are as follows:
Cost threshold for parallelism 5
Max Degree of Parallelism 8
Affinity Mask 1
Query Cost Governer Limit 0

What should you change to enable queries to run in parallel and finish quicker?

Answer: Change Affinity Mask to 0

Explanation: The affinity mask determines which processors can be used for parallel queries. A setting of 1 limits queries to processor 0 only. By changing this to 0, all processors can be used. You could also set this to 15 for all 4 processors in a 4 processor system to enable the bitmask for bits 0-3.

(Continued on next question...)

Other Job Interview Questions

• Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report?
• What are triggers? What are the different types of triggers in SQL Server 2000?
• In SQL Server 2005, if you initialize a subscription using FTP, how is the password sent?
• Which types of replication work with Oracle publishers?
• In Service Broker for SQL Server 2005, you encounter the following setting in one of your queues...
• What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?
• What does NULL mean?
• What does the Log Reader agent in SQL Server 2005 replication do?
• What algorithm is used to encrypt the Database Master Key when it is created?
• Does a root element in an XML document necessarily contain all the content for a well-formed document?
• More...