SQL Server Performance

How to spot breaks in sequences

Discussion in 'Forum Announcements' started by gaurav_bindlish, Jul 16, 2003.

  1. gaurav_bindlish New Member

    How to spot breaks in sequences

    It's often useful to know where breaks in a sequence occur in your data (if you are looking for missing IDENTITY columns in a table, missing invoices in your billing system, and so on) There is no built-in functionality that SQL Server has to address the problem, but it's not difficult to code your own.

    http://www.easy-sql-server.com/index.asp?subject=bseq&page=1
  2. vbkenya New Member

    Great Tip. Overly segmented though - too many unnecessary pages to navigate through.

    Thanks.

    Nathan H.O.
    Moderator
    SQL-Server-Performance.com
  3. thomas New Member

    Yes, a good script though. It's good to know none of our tables have any breaks in their identity fields.

    Tom Pullen
    DBA, Oxfam GB

Share This Page