New answers tagged auto-increment
There are many things that can cause gaps in an IDENTITY column (rollbacks, deletes), but in this case due to the jump I suspect it is this bug - caused by the changes to IDENTITY with the introduction of SEQUENCE: Connect # 739013 : Failover or Restart Results in Reseed of Identity So I bet that if you look in SQL Server's error logs, the rows ...
When inserts are rolled back, the identity values are NOT reset. This is one explanation of the so called "skipped" values.
Top 50 recent answers are included