You are performing a number of SELECT queries on

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

(Continued from previous question...)

You are performing a number of SELECT queries on one of your SQL Server 2005 Service Broker queues and you get a call that applications using the queues are running slowly. What can you do?

Answer: Use the NOLOCK hint when querying the queue.
Explanation: Multiple queue readers can access a queue, but SELECT queries can cause blocking, so you should use the NOLOCK hint when querying the queue.

(Continued on next question...)

Other Job Interview Questions

• Which type of XML variable requires a\one and only one root element?
• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• What does @@MAX_PRECISION return?
• Can you use a CASE statement in a WHERE clause?
• What does REVERT do in SQL Server 2005?
• When using the SQLCMD tool, what does the -V parameter do?
• You have just upgraded your server from a single processor by adding 3 additional processors....
• What result would you expect from this statement? Select * from dbo .MyTable
• What does a @@fetch_status of -2 mean in SQL Server 2005?
• What is the scope of the control permission in SQL Server 2005?
• More...