Alan.B (7/12/2016)
TheSQLGuru (7/12/2016)
Alan: your PK breaks inserts of >1 row with the same datetime value, which is going to happen both with multi-row batch inserts as well as concurrent access (due to the 3.33ms specificity of datetime).This would be true if I did not include an identity column as a tie-breaker 😉
A scrolling we will go, a scrolling we will go ... hi-ho the derry oh a scrolling we will go! 😀
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service