When working with a SQL-Server database when records are removed with a primary key there become gaps 1 which can be problematic outside of normal removal of rows. To find out how to query for gaps ...