Reliable sequential numbers from SQL server

Earlier, I’ve been writing about how gaps are a very normal thing with IDENTITY columns. The same applies for SQL Server SEQUENCES however.

The above might make you wonder how you would reliably get a sequential number from SQL server without any gaps, so this post is about just that.

Continue reading