SQL Server Performance

question regarding primary key

Discussion in 'SQL Server 2005 General Developer Questions' started by puja24, Jan 28, 2006.

  1. puja24 New Member

    Hi,
    I had question regarding my table which has netid, last name, first name information.

    can someone suggest me if it's ok to set primary key on netid column?

  2. Chappy New Member

    If thats all the information youre willing to supply us with, I recommend consulting the magic 8 ball <img src='/community/emoticons/emotion-1.gif' alt=':)' />
  3. FrankKalis Moderator

    If netid is able to uniquely identify each row in your table it looks like a good candidate for the Primary Key. But I agree with Chappy in that you've given us very few informations. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />

Share This Page