Viewing 2 posts - 1 through 2 (of 2 total)
thank you all,
it has something to do with Parameter Sniffing!
It explains a lot!
Is this the best practice? to disable parameter sniffing?
Thank you
March 18, 2010 at 4:48 am
#1135829
I can run it a 1000 times!
the difference is:
the first one with local variables: I get a result in 5 seconds.
the second one without local variables: I get a result...
March 18, 2010 at 3:50 am
#1135800