Forum Replies Created

Viewing 8 posts - 1 through 9 (of 9 total)

  • RE: Best Practices for Database Design

    I guess naming standards fall under the same type of conversation that religion, money and politics fall under.  We all have our opinions and nobody is right, but noone has...



    Dan Avsec
    MCSD, MSDBA, MCT

  • RE: Best Practices for Database Design

    So you change your name as you move from room to room.  LOL.  Thanks Adam.



    Dan Avsec
    MCSD, MSDBA, MCT

  • RE: Best Practices for Database Design

    I totally agree with what you are saying about very rigid standards.  When I develop a database, I try to use naming in a way that would be intuitive to the...



    Dan Avsec
    MCSD, MSDBA, MCT

  • RE: Best Practices for Database Design

    "In the relatively rare case that there is this kind of conflict I will normally rename the fK column."

    Do you find that to be an acceptable solution?  The moment...



    Dan Avsec
    MCSD, MSDBA, MCT

  • RE: Best Practices for Database Design

    I guess I just prefer my data name specifically.  I agree with keeping column names short, but they have to be clear and descriptive as well.



    Dan Avsec
    MCSD, MSDBA, MCT

  • RE: Best Practices for Database Design

    I do alias my fields most of the time.  But if you follow what I said regarding primary and foreign keys, you are implying "name" in one table is related...



    Dan Avsec
    MCSD, MSDBA, MCT

  • RE: Best Practices for Database Design

    Thanks Adam, I will remember that.  LMAO!!!



    Dan Avsec
    MCSD, MSDBA, MCT

  • RE: Best Practices for Database Design

    Regarding the "name" or "description" field.  Let's say you have a field in 2 tables named "name".  The tables are named item and customer.  I have found it much easier to...



    Dan Avsec
    MCSD, MSDBA, MCT

Viewing 8 posts - 1 through 9 (of 9 total)