SQL SERVER 2017 – IDENTITY_CACHE
When we define a table with Identity column, SQL Server might cache the identity values to improve performance. Due to server restart or database failure some assigned values may be lost. …
Read MoreTag: identity property
Identity Property Part – 2
In this blog series, I’m covering all about Identity property. This is the second part of this series. You can read the first part here (Part – 1). After reading this …
Read MoreIdentity Property Part-1
Identity property is one of the most frequently used properties to generate auto increment value. I’ve seen sometime developer get confused with it. So this blog series will help developers to …
Read More