We are trying to avoid opening the code, but it looks like we may have to.

I will check into the parameter sniffing - previously the query was dynamic - i...

It doesn't take much huh? I guess that is why it's recompiling .... the recompile seems to take quite a bit of time too... in the end i'm not...