timothyawiseman (3/21/2008)
Thanks for your help. And I was looking for help in an argument I am in, Grant. If I was right (and the consensus here seems to be that I am) I wanted more arguments to bring to bear in convincing my coworkers. If I was wrong I wanted to be able to change positions before I got myself too entrenched.Any other arguments that might help sway my coworkers?
Sprocs offer tight data security (and encapsulation) that can be easily and efficiently managed by a DBA team. (By encapsulation I mean that the client does not need to know which tables/columns were accessed for the returned data - neither should it know).
Also, sprocs serve to better organize database-access code, meaning better code maintenability and reusability.
You will not get these advantages from db code embedded directly in your client app.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]