Post reply

Compare Current IDENTITY Value to DataType's Boundary

  • November 7, 2013 at 12:37 am

    #300818

    Comments posted to this topic are about the item Compare Current IDENTITY Value to DataType's Boundary

  • December 20, 2013 at 3:11 am

    #1675079

    Script is cool. It works well. However it maybe of more use for Extremely large databases/tables. At my system biggest table of 414 million rows in a table with id defined as int identity(1,1) scarcely takes 0.19% .

    TableName PercentTakenIdentityValueMaxValue

    [dbo].[Entries]0.1928 414052337 2147483648

    Regards,

    IgorMi

    Igor Micev,My blog: www.igormicev.com

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

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