Viewing 2 posts - 1 through 3 (of 3 total)
also found that the sp after recompile ran fast with some input parameters and very slow with others (relating to number of records in one of the joins). Ran...
May 16, 2008 at 8:07 am
#816512
I think the whole process is as easy as running
sp_recompile theBadSpName
you dont need to surround the sp in ''s
it will then be marked for a recompile the next time...
May 15, 2008 at 4:48 pm
#816208