I'll look into the sys.sp_sequence_get_range SP as I've seen someone said it is thread safe. This may be a good solution. (if thread safe)

thank you for the suggestion and clarification on the threading. My process can run multiple concurrently on one service (presently only 1 batch) but there are multiple instances of the...

Using a sequence, can a process get a set of 5000 values and then use those values as the PK? WHILE another process performing the same task in parallel gets...

In this case, we're already using an integer. The reason is the identity is also PK so sorted on that value. I think if we used a GUID then searching...