DEV Community

Discussion on: What have the STORED PROCEDURES ever done for us?

jones1618 profile image
Stephen Jones

So true. I've had sober senior developers argue that SPs are a dinosaur, they are hard to debug, you can do everything they do easier in business-layer code and LINQ queries, etc.

You effectively skewered most of that, especially about abstraction and separation of business/storage layer. VIEWs and SPs let DBAs change their minds (somewhat) about the details of storage, how data is extracted, etc. And, while people are touting the utility of "server-less" functions, SPs and SQL functions are the original version of that, pieces of logic that are tuned and optimized to run closer to the data ... where they belong.