I am experiencing something funny in my database. The primary key increases like:
It happens when SQL server 2012 loses its pre-allocated sequence numbers.
If you want to get rid of that, one option is to use traceflag:
DBCC TRACEON (272)
Another option is to use a sequence (with no caching) instead of identity:
CREATE SEQUENCE MySeq AS int START WITH 1 INCREMENT BY 1 NO CACHE;