Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does Anybody know absolute or relative cost of forzed parameterization in SQL Server 2008?

share|improve this question
up vote 1 down vote accepted

I'm not aware of anything put out by Ms more than the guidelines from Forced Parameterization. If my opinion is of any value, from what i know about this process, the cost of changing the plan to be forced parametrized has a minimal impact on the overal cost of the query. As always, there are always a lot more details that can push the answer into the realms of 'it depends', like: complexitiy of the query, possible impact of parameter sniffing, posible loss of partition restrctions etc etc, but you asked a very generic question.

You can read my reply at on an more detailed explanation on a related topic, why simple/forced parametrization is a far cry from actually using true parameterized queries.

share|improve this answer
i think this is the best answer that i will get, thx – fravelgue Jan 8 '10 at 19:07

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.