Sequence Numbers

This is a SQL object that is seldom used. Might find it useful.

Enjoy

https://msdn.microsoft.com/en-us/library/ff878058(v=sql.110).aspx

This is the way I used to handle this issue.

https://www.mssqltips.com/sqlservertip/1467/populate-a-sql-server-column-with-a-sequential-number-not-using-an-identity/

Finding data islands

http://www.sqlservercentral.com/scripts/119010/