I'm regretting not having used stored procedures in my last major project and it has nothing to do with performance. Performance is fine (and I presume in the same ballpark as SPs) by just using parameterized and prepared statements.

The reason is just maintanability during optimization. It's very convenient having the code that determines 95% of the execution time (database access/T-SQL) available in one place and modifiable on the fly (no recompile).

That being said, this discussion was about views I believe, so I'm posting this in the wrong place . Views and stored procedures have partially, but not entirely, overlapping purposes, so I don't see how anyone could completely discount one for the other.

T.