Should I use NEWID() as my primary key in the table? What datatype I should use for that column?

1.4k views Asked by At

I have read few posts and articles about NEWID() in MS SQL. Before I decide should I use this method or not I would like to get some information. My Single Page App has few tables. One of the tables should store unique key for each customer. I'm wondering if I should use NEWID() also how I should store that id in the table? I was looking over dataypes and there is unique-identifier type. Few articles mentioned that I will have potential problems with performance especially if I would be joining over 100k to some other tables. I will have this scenario where I would have to join these records to different tables. If anyone can provide some answers or suggestions that would be great. Thanks in advance!

Here is example of my Table:

   Column Name     Data Type           Allow Nulls    
    hm_id           int                 Unchecked   // auto-increment id
    hm_studentID    uniqueidentifier    Unchecked   // primary key
    hm_firstName    varchar(50)         Checked
    hm_lastName     varchar(50)         Checked
    hm_dob          datetime            Checked
0

There are 0 answers