Introduction Recently there was a discussion in one of the forums which helped me to learn about a function which has been there for a long time in SQLServer and had eluded my knowledge till now.This article explains on the…
SQL 2017 Tips: Tweaking IDENTITY_CACHE Setting to Avoid IDENTITY Column Gaps
Introduction In my discussions with my fellow colleagues as well as on my online interactions with the developer community, I’ve come across a good amount of cases where people have raised a concern over the IDENTITY behavior in SQLServer.As you…