Browse by Tags

• Gaps

• Finding (all the) gaps in an identity column (or any integer based column for that matter) using Sql 2005

  We're often asked how to determine gaps in an identity column. For Sql 2000, there are quite a few references out there (my favorite, and probably the most scalable solution I've found, is a morph of a solution created by Umachandar Jayachandran... Posted Oct 15 2007, 11:16 PM by Chad Boyd with | with 1 comment(s) Filed under: Gaps, Identity, CTE