Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clear cache?
Message
From
20/06/2000 18:26:35
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00382225
Message ID:
00382455
Views:
22
Mike,

I had tried WITH RECOMPILE to no avail - I don't have the book - so if you happen to find time to look that up, I would be appreciative.

thanks!
Ken


>Ken,
>
>First, you could try executing the stored procedure with the WITH RECOMPILE option, which would cause SQL Server to reoptimize the stored procedure. The original query plan would remain in cache, eventhough the BOL says otherwise.
>
>There are two DBCC commands, neither of which I remember off the top of my head. If you have a copy of Inside SQL Server 7.0 (Delaney), both are covered there. I just don't have my copy handy.
>
>-Mike
>
>
>>Hi,
>>
>>I have a stored proc that drags like crazy "first time each day or session" it is run. After that it runs fine (I assume becuase it is compiled and cached) making it difficult to figure out where the problem is. Is there a command/function that can clear the procedure cache and force this procedure to always act like it is "first time of the day"?
>>
>>TIA,
>>Ken
Ken B. Matson
GCom2 Solutions
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform