• Revenant (7/31/2013)


    PhilipC (7/31/2013)


    Revenant (7/31/2013)


    PhilipC (7/31/2013)


    Revenant (7/31/2013)


    SQLRNNR (7/31/2013)


    PhilipC (7/31/2013)


    Has anyone noticed how vendor databases in general are getting worse and worse? It seems we're getting to an age where regardless of quality, it's just get the product out the door as quickly as possible.

    The company I work for just purchased a product which landed with me to install the database, and what I find is a database with very few tables actually having primary keys, no indexes and after a big data load they wonder why the performance is shot to hell.....

    I am in the same boat with several of my clients.

    They have vendor databases that are really pathetic in design and performance - and the vendor won't provide any real support other than to tell them to get better hardware.

    You are not talking about SharePoint per chance, are you? 🙂

    Haha no, but it is a financial piece of software. Best left unnamed.

    I just fail to see how databases without the base core of primary keys, foreign key constraints, indexes, etc can be overlooked in any database before shipping it out to a customer.

    Have you ever looked into ReportServer database? Now that is a duly constituted part of SQL Server.

    A bit different though IMO as it isn't a true OLTP database.

    Well yes, it is not OLTP, but IMO it ought to be an example of a good design. I was trying to make the point that it is not, unfortunately.

    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.