title: SQL Server 2008 identity Key auto increment Issue
body: <p>I recently had to move a database(sql server 2008) to a different server, and I have noticed that in one of the table, the value of identity column has started to get some unexpected values. its set as identity column with  identity increment 1 and identity seed 1. After every 10 consecutive entry or so, it would start from another much higher number and increment by 1 for next 10 entries or so and then jump up to another higher number. I can't seem to figure out the issue. </p>
  
  <p>Sorry for the layman language. I am not a DB person. </p>