>Yes, correct, SQL Profiler shows everything in sp_executesql approach. I guess I will adjust the data class of my framework to use it back and I will see how it goes today with more tests I will do. It might not be that much on a per transaction basis to save one hundred of a second, but at large scale, this might mean that we could support up to thousands of additional hits per day within the same infrastructure.

The only time saved, if any, will be on application side on parameter handling. Than again, you'll have to convert parameters into string for sp_executesql approach. It's hard to tell upfront if you'll gain anything.

>
>BTW, I was just curious to know what development platform you are using or is it mostly some DBA stuff at the server level?

It's hard to explain but in general I don't deal with frontend stuff. :)