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
IDENTITYcolumn, or abandoningIDENTITYaltogether 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.