SQL Server 2008 finding missing rows -

SQL Server 2008 finding missing rows -

this question has reply here:

sql query find missing sequence numbers 14 answers

i have huge db , 1 table in particular missing rows. know true need find gaps , show them. primary key sequence number column. need show actual missing sequence numbers. table has 76,054,525 rows of data.

update, sequence number provided our software , each 1 represents unique "play" record. our software not allow gaps in play sequence numbers. gaps missing data.

that gaps , islands problem , lot of people have written how solve that. example, itzik ben-gan covered in chapter 5 of sql server mvp deep dives book

however, why worried gaps in identity column? naturally occurs , cant prevented. can read more here: http://sqlity.net/en/792/the-gap-in-the-identity-value-sequence/

sql sql-server-2008 gaps-and-islands missing-data