Hi,
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?
Thanks,
Von Scarberry
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?
Thanks,
Von Scarberry