Which is Faster??

[Glowworm27]

I have a SQL task in my DTS package, I was wondering is it faster to have the actual SQL script in the SQL task, or is it faster to have the SQL Task Execute a stored procedure that does the same thing as the SQL script?



George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips

 

[TheJon]

Stored procedures can be quicker than straight SQL especially if there is conditional processing. Also a query execution plan is created on first running, and cached, so if the Stored Procedure code remains static it reuses the execution plan.




[tt]|_ |_ _ | _ _
|, | )(/, |(_)| )
'[/tt]

 

[Glowworm27]

OK thats what I thought, Just wondered if having the SQl execute from inside a DTS package made any difference.

thanks

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips