Community

How to Eliminate Gaps in Identity Values in SQL Server by Disabling the Identity Cache

(Greg Larsen) Have you ever heard of the identity cache? If not, it is just a cache that stores the next 1000 available identity cached values for a table.