Globally Unique Identifiers (GUID) In SQL Server
In this post we will learn about Globally Unique Identifiers (GUID) In SQL Server.Globally unique numbers(GUID) data type actually holds information that is designed to be created and viewed using the standard 32-digit hexadecimal format.To generate such a value, the NewId() function is called.
Advantage:
- Unique across the server.
Disadvantage:
- String values are not as optimal as integer values for performance when used in joins, indexes and conditions.
- More storage space is required than INT.