Compare SEQUENCE cache size, restart gaps, rollback gaps, and insert throughput with CACHE 50, CACHE 1000, and NO CACHE.
Migrating From MySQL to SQL Server: AUTO_INCREMENT, LIMIT and Other Differences
Plan migrating from MySQL with clear translations for identity values, paging, dates, booleans, string functions, and upserts.
Negative Identity Seed and Negative Increment in SQL Server
A Negative Identity seed lets a column start below zero, and a negative increment makes it count down. This post tests IDENTITY(-1,-1) and IDENTITY(-2147483648,1) on SQL Server 2025, shows gaps after a rollback, DBCC CHECKIDENT, and what to do when an int identity runs out. It also shows SEQUENCE as the flexible alternative.
Sequence Gaps: Why NEXT VALUE FOR Skips Numbers
Explain sequence gaps, inspect cached values, test rollback behavior, and separate SQL Server identifiers from gapless numbering.
SQL SERVER – Enable Identity Insert – Import Expert Wizard
An SSIS package failed with an identity error because both tables had identity columns. Checking Enable identity insert in the Import Expert Wizard fixed it.
SQL SERVER – Find Gaps in The Sequence
How do you find gaps in a Sequence of numbers? A reader asked, and two experts, Brian and Tejas, replied with good scripts. Here are both solutions.
SQL SERVER – Add or Remove Identity Property on Column
There is no direct T-SQL to add or remove the identity property on an existing column. Imran Mohammed shows how SSMS does it and what happens behind it.