fmuzul (3/11/2013)
Gazareth (3/11/2013)
Well, I think you've got both ends of the argument there in the last couple of posts!But what's with the paranoia over DBA's Francesco? We're not all bad 🙂
I don't think I'm paranoic over DBA's.
I just think that sometime they overestimate the benefits of using s.p., and underestimate the problems they can give.
The biggest problem with having the SQL code embedded in the application code comes to tuning the code. Any rewrites of the embedded code require a redeployment of the application. If the code is contained inside of a stored procedure, only the stored procedure needs to be redeployed, not the entire application.