About Identity columns…

Keep a check on your IDENTITY columns in SQL Server

bigint identity impact on table size in SQL Server Datawarehouse