rowguid as a primary key

Question

3.40/5 (2 votes)

See more:

SQL-Server-2008

i create a unique identifier called rowguid like this

SQL

rowguid uniqueidentifier default newsequntialid()

this generates unique rows. Is it a good idea to use the rows generated as primary key?

Posted 6-Oct-13 23:23pm

Rakshith Kumar

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ryan Zahra · Accepted Answer · 2013-10-06T23:31:00

Solution 1

From my personal experience, I always prefer a sequential auto-number as a primary key for any given table.

The function newsequntialid() does not guarantee that the guid is always really sequential. Keep in mind that these are sequential and, in theory, you might also end up with duplicates.

Further more, read here for a more detailed explaination

Posted 6-Oct-13 23:31pm

Ryan Zahra

Comments

Rakshith Kumar 7-Oct-13 5:33am

Agreed with the points that you have told.
I can use
rowguid int identity(1,1) primary key.

Can you please tell me a scenario wherein i can use rowguid

Ryan Zahra 7-Oct-13 5:43am

The rowguid is mainly used to solve page-split clustered indexes