Slow response with Bind vars in SqlServer

[FRBhote]

When we use bind variables and query MS SqlServer, the time taken is enormous. With constants, the result is immediate.

Is there some setting to be done to increase the speed?

[Jeff Luther]

Need to have you quantify "enormous" a bit closer. "bind variables" -- how many in the WHERE clause? There's no 'setting' that I know of (TD has to so symbol lookups for each), but a sample query and some metrics might give some clue as to the issue.

[FRBhote]

Forced Parameterization did the trick

http://technet.microsoft.com/en-us/libr ... .105).aspx