>I have records in a table which have the exact same timestamp. This is because they are in the same millisecond. Is there a way to increase the precision in SQL Server to go higher than that?
Yes, check DATETIME2 type in BOL
If it's not broken, fix it until it is.
My Blog