karthikeyan-444867 (4/5/2010)
The REPLACE solution can be made to run an order of magnitude faster if we use an in-line table-valued function instead of an evil scalar function:
I am not getting the exact meaning of this statement. what do you mean by order of magnitude?
Order of magnitude = 10 times faster.
you mean to say even though if we use REPLACE function in an in-line table valued function the performance will be good. Am i correct?
Yes. Test it, and examine the query plan to understand it fully.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi