Aaron Bertrand has part 3 in his series on identity columns:
This post investigated two potential workarounds to either buy you time before changing your existing
IDENTITY
column, or abandoningIDENTITY
altogether right now in favor of aSEQUENCE
. 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.