SQL Server Performance

identity key

Discussion in 'SQL Server 2008 General Developer Questions' started by raviatvns, Mar 2, 2011.

  1. raviatvns New Member

    do i use identity column as a foreign key
    raviatvns, Mar 2, 2011
    #2

  2. Adriaan New Member

    If you do, you do. And if you don't, you don't. What was your question, again?
    Adriaan, Mar 2, 2011
    #3

  3. FrankKalis Moderator

    You hardly would use an IDENTITY column as a foreign key. You may however use it as a primary key in your parent table and then use a column of the same type in a child table to create the constraint between both tables.
    FrankKalis, Mar 2, 2011
    #4

  4. satya Moderator

    I doubt this is a classroom/interview based question...
    satya, Mar 7, 2011
    #5

  5. FrankKalis Moderator

    [quote user="satya"]
    I doubt this is a classroom/interview based question...
    [/quote]
    if so, there are smarter questions out there.
    FrankKalis, Mar 7, 2011
    #6

  6. jcelko New Member

    IDENTITY is the count of the physical insertion attempts to a table. Why would you think that it can ever be a key in a properly designed RDBMS? Please read any book on data modeling and RDBMS.
    jcelko, Apr 4, 2011
    #7

  7. satya Moderator

    Hey Joe,
    Welcome to the forums.
    Glad to see your inputs here...hope to see them regularly, your insights are very helpful.
    satya, Apr 5, 2011
    #8

  8. mmarovic Active Member

    Sorry, I have slow connection here and it appeared to fail once, then the response appeared twice. Somehow I do not see an option to delete post, so please read next one. @moderators: Please delete this one if possible.
    mmarovic, Apr 5, 2011
    #9

  9. mmarovic Active Member

    [quote user="jcelko"]
    IDENTITY is the count of the physical insertion attempts to a table. Why would you think that it can ever be a key in a properly designed RDBMS? Please read any book on data modeling and RDBMS.
    [/quote]I don't know what is properly designed RDBMS according to you. However, this is MSSQL Server forum and identity can be a primary key and it shouold be in most cases.
    mmarovic, Apr 5, 2011
    #10

  10. satya Moderator

    I would still agree with Joe's comments that MSSQL is built upon RDBMS principles, why would it is different to that.... in terms of architecture.
    satya, Apr 6, 2011
    #11

  11. jcelko New Member

    Real SQL programmers never use IDENTITY at all. It is the count of the physical insertion attempts. That is physical meta data and is not RDBMS.
    jcelko, Apr 19, 2011
    #12

  12. Luis Martin Moderator

    [quote user="jcelko"]
    Real SQL programmers never use IDENTITY at all. It is the count of the physical insertion attempts. That is physical meta data and is not RDBMS.
    [/quote]
    Modesty is not your best virtud.
    Anyway, welcome to the forums.
    Luis Martin, Apr 19, 2011
    #13

  13. mmarovic Active Member

    mmarovic, Apr 20, 2011
    #14

Share This Page