Developers love database programming tips, tricks, and workarounds—especially those that slash development time or boost application performance. Here's a collection of such nuggets for developing SQL ...
CREATE TABLE SequentialIdTable (A int identity, B uniqueidentifier DEFAULT NEWSEQUENTIALID()); CREATE TABLE IdTable (A int identity, B uniqueidentifier DEFAULT NEWID()); CREATE TABLE RowVersionTable ...
A ULID is a Universally Unique Lexicographically Sortable IDentifier. Basically it's a GUID (or UUID) that "sorts well" which is important for indexes databases and data structures. However, it still ...