Hi,
Anyone faces this issue, of why the same SP in SQL2k SP4
when initially run, is fast and okay.
However, when i run it the second time or more, it just
keep getting slower from 30seconds to 2minutes.
Anyone know who or how it is happening.
My SP just using a cursor and even when
I change it to using loop, it does not
help.
Thank you
Best Regards
Virusim