Mike

Excellent article. Just last week I had a tough time with my frontend dev team. I refused to add string formatting in stored procedures and the dev team was almost forcing me to do it in SP. Finally I took my stand and said NOOO. When the manager asked the develpers what is the problem in doing the formatting in the front end, there was a quite silence and they agreed to do it in the front end. Later i did a google and sent them an article which clearly explains why string manipulations should be avoided in stored procedures

I wish the front end developers understand that for the performance of the application it is a good idea not to load the SQL Server.

No one thinks of longterm impacts, they just want to do a easy and fast fix!

Ranga