NEWSEQUENTIALID

Should I Use A Unique Identifier As A Primary Key?

by SteveStedman
September 6, 2021August 4, 2021
4 Comments
Performance

Take the following sample code. Four similar tables with an INT IDENTITY, BIGINT IDENTITY, and two with UNIQUEIDENTIFIERS, one using newid() and the other… Read More »Should I Use A Unique Identifier As A Primary Key?

Should I Use A Unique Identifier As A Primary Key?

by SteveStedman
August 13, 2012March 11, 2015
Performance

Take the following sample code. Four similar tables with an INT IDENTITY, BIGINT IDENTITY, and two with UNIQUEIDENTIFIERS, one using newid() and the other… Read More »Should I Use A Unique Identifier As A Primary Key?