Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

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 http://stackoverflow.com/questions/1608522/dynamically-created-sql-vs-parameters-in-sql-server/1608856#1608856 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

 
discard

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.