4 ms·
The one point I went looking for and didn't see is that UUID's make for very poor clustered indexes. SQL Server tried to mitigate this with the 'NEWSEQUENTIALI
by braveo 9y ago
The one point I went looking for and didn't see is that UUID's make for very poor clustered indexes. SQL Server tried to mitigate this with the 'NEWSEQUENTIALID', but it essentially 'resets' when the server is rebooted.
If your data is small enough that it doesn't matter then fine, but in general UUID's are better as a surrogate key than as a primary key.
- jrochkind1 9y agoYes, that's in the OP, exactly what you said.
- braveo 9y agoIt was, I meant I went looking for it in the article and didn't see it :)
- UK-AL 9y agoVery few people generate the guids database side. They normally generate them before they even insert it into the database.