So in the middle of basic coding and testing we saw a huge non-patterned jump in Identity values for multiple tables. We are unaware of any server blips or attempted bulk operations, but DBAs are looking into logs. The gaps are not the typical 1,000 or 10,000 seen with server restarts and such. The gap for Application_NO is 10,410,345 for a table with 2,320 rows and Transaction_Payment_NO jumped an astonishing 1,712,149,313 for a table with 685 records. Any ideas on what could be causing such large and seemingly arbitrary jumps.
Go to Source