I am contemplating using a
datetime2(7) as a clustered index.
If I were to always populate that column using
SYSDATETIME is it possible for the same instance to issue the same value twice (assuming we don't do something like set the system clock back)?
Alternatively, what is a cohesive strategy for ensuring uniqueness on such a column, even if it that comes at a cost of time precision?
For my use, I really only care about the seconds, but I will be doing a lot of range queries on this column so the CI seems appropriate.