• It would be better to put all virtually static lookup tables in their own file/filegroup and only backup that filegroup or do index maintenance when something changed.

    As far as putting all lookup tables in their own lkp schema, that would make it obvious that a table was a lookup table but it's a whole lot like prefixing table names with "tbl_", which I don't care for at all. It would also separate lookup tables from their dependent tables and that can make life a real pain when you look at the tables in Object Explorer.

    Personally, I'd dump the idea of using a separate schema for lookup tables.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)