I work with huge datasets. Many of the transactions that take place in my database are enormous - trillions of rows, and more.
Some of the tables use IDENTITY columns, not for unique IDs, just because its simple and fast, and to provide a concurrent solution to providing an incrementing number. However, when the IDENTITY column reaches its limit, I want it to automatically reseed immediately within the statement when it reaches its limit. I appreciate this is odd behaviour for most, but it would make sense to at least have this functionality as an option, surely? You can't even do a reseed within a transaction, and I cannot use truncate (don't want to delete).
Why is this not possible? Has anyone else come across this as a problem before?