What is the way of tunning the stored procedures ? 'set showplan'
shows the plan of single query only , is there any DBCC command for
kindly let me know .
> What is the way of tunning the stored procedures ? 'set showplan'
> shows the plan of single query only , is there any DBCC command for
> this purpose.
> kindly let me know .
Post the example if your still having problems.
I have an ASP Application that sends out bulk emails. Initially I was
using inline SQL statements. The inline SQL Statements were converted
to Store Procedures for better performance. Unfortunately it ended up
degrading the performance by half of the initial rate.
Does any one have any suggestions to the causes and remedies if any
8. Newbie ?.