pros-and-cons of using database-generated integer vs client-generated
Guids, and introduce
NewId as a way of mitigating some of the downsides of
NewId is designed to solve a specific problem. It's for when you want a unique ID, but you want them to generally be , and semi-predictable.
be170000-f32d-18db-de59-08da26f2ad5a be170000-f32d-18db-1816-08da26f2ad5b be170000-f32d-18db-8694-08da26f2ad5b be170000-f32d-18db-4dbd-08da26f2ad5b be170000-f32d-18db-65b3-08da26f2ad5c
Guids have caused nearly 99% fragmentation in the (SQL server database) index, whereas the
NewIds have caused only a 5% fragmentation.