Tag Archives: SQL Server Sequence

SEQUENCE BREAKS / GAP in Numbers after Restart SQL Server (gap between numbers after restarting server)

A user reported that there is huge GAP between numbers generated by SEQUENCE after restarting the SQL Server. bit surprised, Don’t worry this is Expected behavior of SQL Server. If you don’t know that Sequence like Identity is new feature of SQL Server 2012, please check my previouos post How to Create and use Sequence [...]