[Philip-J-Fry]

Timestamps no matter how precise don't show you the true order. If ordinality is so important then you should be using something else that guarantees ordinality, like an incrementing ID or something, not timestamps.

[jimlikeslimes]

Yes I think in the end I'll likely go for an GUID Id column, an integer InsertOrder column, and a timestamp which is non-essential meta-data.