How can you get SQL Server 2005 to simulate mult

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

(Continued from previous question...)

How can you get SQL Server 2005 to simulate multiple processors for query testing?

Answer: Use the -P parameter in the startup parameter list.

Explanation: You can use the -Px trace flag in the startup parameters, where x is the number of processors to simulate. Beware of using numbers higher than 4 on a single processor machine. Also note that this is unsupported by Microsoft.

(Continued on next question...)

Other Job Interview Questions

• What message types exist in SQL Server 2005 Service Broker?
• You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do?
• To maintain the best performance of your SQL Server 2005 databases, how should you deploy encryption technologies?
• If you run this, what does it return? select applock_mode('public', 'SalesApp', 'Transaction')
• How many of these servers can you consolidate?
• Which of the following is not available to you?
• What does this method in SQL Server 2005's SMO equate to in T-SQL? db.CheckTables(RepairType.None)
• Where are Notification Services event messages logged in SQL Server 2005?
• Your SQL Server 2005 Express Edition locks up frequently and cannot be accessed. How can you enable the dedicated administrator connection?
• In SSIS, what is the difference between output columns and external columns?
• More...