By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

SQL 2005 and Ad Hoc queries not taking advantage of parallel processing.

P: 1

I have a question concerning SQL 2005 and Ad Hoc queries. For performance due to omitting unnecessary joins based on parameters. I have created an Ad Hoc SQL statement to increase performance. Although the CPU and IO reads are greatly reduces the SQL takes longer to execute. Our internal DBA have determined that the newer query was not taking advantage of parallels. Do AD Hoc statements in SQL 2005 qualify for parallel processing?

Von Scarberry
Dec 30 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.