>>There are also those who think that SPs only is the best way for >performance, when many of these build improper SPs or build SQL within >these SPs that do not perform well.
>
>
>Or, don't have the proper indexes. I inherited an all SP system with some horrible performance problems. The DBAs would nit-pick over variable naming conventions, table variables vs cursors, etc; but nobody ever questioned the decision to accept the default of the clustered index on the primary key.

Yes, stupidity and ignorance rules the world. I firmly agree...