I have a table that gets a fresh set of data from our source each day. This mean I DELETE almost all the records each day and repopulate it with new data.
I do not TRUNCATE the table because according to business rules all the records can't be deleted, so my script is:
DELETE FROM Table1
This deletes almost all the records each day.
Being a DELETE, this means the primary key column, which is an IDENTITY, does not get reseeded but rather this values just keeps getting bigger and bigger.
I am running into a scenario where the INT data type on this IDENTITY column is going to become too small.
My ID column is on 1,500,254,112 and the maximum for an INT is 2,147,483,647.
Now before I just go and change the data type to a bigint, I was hoping someone could give me a better solution to keep the ID value in check?