Post reply

Identity Increment Recycles?

  • March 31, 2003 at 9:37 am

    #79820

    Hi,

    Will SQL Server 2000 recycle through unused numbers when it reaches the end of the range of numbers that bigint offers on an Identity Increment Primary Key field?

    Thanks for the help,

    Tom Halladay

  • March 31, 2003 at 5:15 pm

    #452655

    SQL will not recycle IDENTITY values.

    There was an article somewhere that did all the math to work out how long it would be before each datatype ran out of identity values. Can't recall where it is now, but I do recall that at a rate of 10000 inserts per second, bigint would run out in 93 years.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • April 1, 2003 at 9:42 am

    #452721

    Thanks for the info. Our client will likely be chewing through a couple thousand per day tops, so I think we should be safe then. Or at least, I won't be around once they run out anyway. Thanks again,

    Tom Halladay

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply