Sequence Numbers [!INCLUDE SQL Server Azure SQL Database] A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to the specification with which the ...

The sequence numbers need to be accumulated within a specified interval, which requires grouping these intervals or embedding window functions in case when, which can be very convoluted.

See the latest SQL Server Best Practices brought to you by the experts at Microsoft SQL Server Blog.

The recommended availability platform for SQL Server: Stratus ftServer Not your father’s fault tolerant server Partner blog post from Peter Cook, Director of Global Alliances, Stratus “The latest SQL ...