Call me old fashion but I really like integer autoincrement primary keys. It's easy to understand and obviously simple to sort. Furthermore when working on large batch projects you can just store the last primary key as your high water mark and get everything greater than that.
I suppose TSID works to this end, but certainly more complicated.
I suppose TSID works to this end, but certainly more complicated.