SQL Server 2012 Identity Column Increases by 1000
Posted on 2015-02-11
I have several SQL Server databases. I have hundreds of tables that use an Identity on the primary key to increment the value.
I upgraded to SQL Server 2012 about 6 months ago. Twice since the upgrade, my Identity value has jumped by around 1000.
I have hundreds of tables that use the identity column, but the jump has only occurred on a couple of the higher use tables. For example, the Return Order table, has twice jumped by around 1000 places.
As a programmer, a number is a number and I could really care less, but the end users don't like to see that two sequential orders are numbered 8001 and then 9001.
Can anyone explain why this is happening and what can be done to prevent it in the future?