See https://dba.stackexchange.com/questions/133556/can-i-rely-on-reading-sql-server-identity-values-in-order/135116#135116. With SQL Server, there's a slight possibility that checkpoint have gaps because of a ongoing transaction