3 ms·
> SQL Server has a sequential uuid type which avoids exactly this problem. you refer to the uuid generated by sql server?
by cerved 5y ago
> SQL Server has a sequential uuid type which avoids exactly this problem.
you refer to the uuid generated by sql server?
- hobs 5y agoProbably just https://docs.microsoft.com/en-us/sql/t-sql/functions/newsequentialid-transact-sql?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/t-sql/functions/newsequ...
- philliphaydon 5y agoYes. When generating you can use NewSequentialId() which generates a sequential guid to avoid needing to reorganise indexes.