Are GUID collisions possible?

by

Basically, no. I think someone went mucking with your database. Depending on the version GUID you’re using the value is either unique (for things like version 1 GUIDs), or both unique and unpredictable (for things like version 4 GUIDs). SQL Server’s implementation for their NEWID() function appears to use a 128-bit random number, so you’re not going to get a collision.

For a 1% chance of collision, you’d need to generate about 2,600,000,000,000,000,000 GUIDs.

More Related Contents:

  1. What are the best practices for using a GUID as a primary key, specifically regarding performance? [closed]
  2. How can foreign key constraints be temporarily disabled using T-SQL?
  3. Connection to SQL Server Works Sometimes
  4. Combine two tables that have no common fields
  5. Is it possible to use Full Text Search (FTS) with LINQ?
  6. How to set a default value for an existing column
  7. Need a datetime column in SQL Server that automatically updates when the record is modified
  8. how to make your data horizontal
  9. How do I find a stored procedure containing ?
  10. Error: TCP Provider: Error code 0x2746. During the Sql setup in linux through terminal
  11. How to check if a Constraint exists in Sql server?
  12. Access is denied when attaching a database
  13. Getting an odd error, SQL Server query using `WITH` clause
  14. An attempt to login using SQL authentication failed
  15. What does “ORDER BY (SELECT NULL)” mean?
  16. Parse XML in SQL Server
  17. Calling stored procedure using VBA
  18. How to find SQL Server running port?
  19. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  20. Changing SQL Server collation to case insensitive from case sensitive?
  21. SQLServer IDENTITY Column with text
  22. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  23. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  24. Cannot bulk load. Operating system error code 5 (Access is denied.)
  25. INFORMATION_SCHEMA vs sysobjects
  26. Does query plan optimizer works well with joined/filtered table-valued functions?
  27. Generate table relationship diagram from existing schema (SQL Server) [closed]
  28. Bootstrapping SQL Express from WiX?
  29. Error converting data types when importing from Excel to SQL Server 2008
  30. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?

Leave a Comment