title: Identity field not sequential
body: <p>I have an Azure SQL database, which contains around 20 tables. I just saw that one of them that the identity field (primary key) is incrementing by 1 for a while and at certain point it jumps with a random number. This happens at two places. First with 1029 and then with 997. They are not related to deleted records or using the CHECKIDENT RESEED.</p>
  
  <p>Any ideas how can I check what causes it?</p>