Home Forums Database Design Relational Theory Is having a lookup table that is for multiple entities a common practice? RE: Is having a lookup table that is for multiple entities a common practice?

  • February 12, 2017 at 12:42 pm

    #1928012

    Doctor Who 2 - Saturday, February 11, 2017 6:54 PM

     How can I simulate load onto this table, such as might happen in production?

    Gut feel, load will not be the first problem you run into. First will probably be data integrity problems caused by bugs in the apps or people changing stuff in the DB (or things like Excel connected directly to the DB), and that's not really something you can simulate

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass