This post investigated two potential workarounds to either buy you time before changing your existing
IDENTITYcolumn, or abandoning
IDENTITYaltogether right now in favor of a
SEQUENCE. If neither of these workarounds are acceptable to you, please watch for part 4, where we’ll tackle this problem head-on.
This is your weekly reminder to plan for appropriate data sizes.