PhilipC (7/31/2013)
Yeah that's a fair enough point. Most of time, it seems to be rapid development over quality development that wins out. As a DBA, it just becomes a nightmare trying to support these kind of databases and maintain some kind of performance level when the vendors show very little interest in improving things.
I've had good luck working with support people if I show them my tests, results ,and recommendations for indexes or FKs. FKs are hard because sometimes their data models are broken and explicit FKs break functionality as well as ensure things are correct, but often I've had them take indexes back to their developers, get approval for me to test them. I've even seen a couple of them make it into upgrades for patches or new versions.