Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Use of uniqueidentifier and NEWID on SQL 7

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-05 : 10:46:15
Tom writes "Windows NT Server 4.0 Service Pack 6a
SQL Server 7.0 Service Pack 2

Goal
Come up with a unique identifier scheme and try not to do use something that effects performance negatively.
That being said is using uniqueidentifier a good idea? If not why?
And does using NEWID put any kind of performance hit on a SQL Server?

If this is not the best way to implement a unique identified what is a better way?
Thanks"

   

- Advertisement -