• 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.