Harsh improved the identity query from Part 1 so it also works when seed values or increment values are not 1. Here is his script.
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype
Mark Hickin improved my old query, so it now shows seed, increment and current identity column value along with the max value of the datatype.
Clustered Key Choice for Date Range Queries: Date or Identity
Should you cluster on OrderDate? Measure one month of orders on three designs and see what each one costs in reads before you rebuild a table.
SQL SERVER – How to Add an Identity Column Using the IDENTITY Property
How do you add an identity column to a table in SQL Server? I explain three cases using the IDENTITY property, including why a second one fails.
SQL SERVER – Add Identity Column to Table Based on Order of Another Column
A reader wants to add identity column values to an existing table in the order of another column, not the default order. Here is my answer. Do you know a better one?
Reseed an Identity Column in SQL Server: SQL in Sixty Seconds #051
To reseed an identity column, run DBCC CHECKIDENT with the RESEED option. The tests here show which value comes next after existing rows, DELETE and TRUNCATE, and what happens when the new value collides with a key.
Adding IDENTITY to an Existing Column With ALTER TABLE SWITCH
Add IDENTITY to an existing column with an empty matching table, ALTER TABLE SWITCH, a reseed, and full dependency checks.