I am using Azure SQL Server and have a user table with an auto incrementing identity column. The identity ID has jumped from 4800 to 12000 to 52000 in just the last three inserts. I understand there can be gaps, but why such a large jump? Is this something I need to fix?
Asked
Active
Viewed 31 times
0
-
Have a look at this question http://stackoverflow.com/questions/14146148/identity-increment-is-jumping-in-sql-server-database – Pரதீப் Jul 02 '16 at 17:11
-
This is helpful. Thanks. – Mercer Jul 02 '16 at 17:47