You want to speed up your SQL Server 2005 Servic

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

(Continued from previous question...)

You want to speed up your SQL Server 2005 Service Broker queue by placing an index on it. What is the best way to do this?

Answer: You cannot create an index on a Service Broker queue.
Explanation: You cannot create indexes on SQL Server 2005 Service Broker queues.

(Continued on next question...)

Other Job Interview Questions

• Which index rebuild operation in SQL Server 2005 can be performed online?
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• Which key provides the strongest encryption?
• Which key does the OPEN MASTER KEY statement open?
• Which table would you query in your report to get logging information about a job step?
• What's SQL Server
• How many connections are available in SQL Server MSDE 2000?
• In SQL Server 2005, what is the maximum size of an index key?
• What does the max full-text crawl range option do?
• What is the timestamp datatype used for?
• More...