In case a table has an auto-incremental ID column, it may sometimes be appropriate to reset its base value (for example, after a truncate table).

DBCC CHECKIDENT ('tableName', RESEED, 1)