Hi,
Sorry the link didn't stick, here it is
http://support.microsoft.com/kb/224453/en-us>Hi,
>
>First, thank for your guide but which KB article are you referring to.
>Sorry for my ignorance.
>
>
>
>>Hi,
>>Working thru this KB article and it's links usually will identify the problem.
>>
>>
>>>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
Regards N Mc Donald