SQLTeam.com | Weblogs | Forums

Run Store Procedure

Dear Friends,
I have Store Procedure When First Run is Slow but Second Run is Faster
I need to solve the problem

Thank You

that's not saying too much. What does it do? How often is it run, maybe second time is hitting procedure cache and first time it has to generate the cache

The only way you can do that is to prevent recompiles and keep all the data you need in memory all the time.

On a busy system, the latter may be difficult to do especially since most code is performance challenged and resource hungry.