3 ms·
Do NOT do that with MS-SQL. The uniqueidentifier type shuffles byes around and does not give you the ordering you want. So whether you use ULID or UUIDv7, save
by dagss 2y ago
Do NOT do that with MS-SQL. The uniqueidentifier type shuffles byes around and does not give you the ordering you want.
So whether you use ULID or UUIDv7, save it as binary(16) in MSSQL.
(There is a special custom UUID implementation someone made for MSSQL that will sort time-ordered on MSQL but nowhere else; IMO that is too niche...just use binary(16)...)