Re: Different execution plans from c# code and MSSQLServerManageme

Hi Wayne,

> Look at using the "WITH RECOMPILE" option when creating or running your pr
ocedure
> and see if that keeps the performance stable.

As reproducong the original situation is not as simple as I'd like to,
I still have to wait and see if we get into trouble with the WITH
RECOMPILE option.

In some troublesome procedures I included the WITH RECOMPILE option, in
others I included WITH(INDEX(...)) hints.

Now I'm waiting to see if any of them start behaving badly.

I observed though that WITH RECOMPILE slows down the execution a little
bit.

OTOH it will always produce optimized execution plans. Right?

Greetings,
Csaba