Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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...
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only