Uniqueidentifier vs. int identity(1,1): Discuss.
So I'm being thrown at a Microsoft Dynamics CRM application, and I see that all the PK / FK's are uniqueidentifier, and not the int identity(1,1) I've seen on almost every other application I've worked with.
Question: What is the advantage of uniqueidentifier, as opposed to int identity(1,1) ?
Thanks in advance.
Jim
Question: What is the advantage of uniqueidentifier, as opposed to int identity(1,1) ?
Thanks in advance.
Jim
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Identity does an auto update whereas uniqueidentifier is data specific.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks all. Points awarded based on perspective that I counldn't find with a standard Google search. -Jim
int identity(1,1) uses less space and sequential so it is faster.