Another Stop-Gap Solution for the SQL Server 2012 Identity Crisis – SQLServerCentral. SQL Server 2012 generating non-sequential identity values? In my coding I never assume the value of a new identity field, which sometimes makes for extra work and could slow down high-volume code, but evidently some applications do assume. If yours … Continue reading →