DSXchange

devesh_ssingh wrote:please share any long term solution which would not exhuast in span of 10 years.

Not sure how anyone can guarantee a "10 year solution" for you, not knowing your data volumes. Regardless, make sure your ids are "big enough" to hold whatever they need to hold.

However, is there really anything wrong with a negative number for a surrogate? (note I said "negative" not "-ve", an abbreviation that irks the crap out of me) Unless you've assigned special significance to them, then I don't see an issue per se. However, you could "fix" this and leave the existing values in place or "correct" them if they bother you, that's just math and some constraint games.

Thanks craig for Quick response...

no issuew with negative id but they will again exhausted with in 2-3 years.
our data volume is 12 billion...

need to find out long term solution

devesh_ssingh wrote:change of data type from Integer to Bigint

Would that not do it for you?

That would do but , for all the -ve values needs to correct..
since restoring last positive value in .sk file and will correct all -ve id with new one.

There's nothing wrong with negative values for surrogate key.

All a surrogate key has to provide is uniqueness.

If you're really bothered by this, use unsigned integers when viewing them. The binary storage is exactly the same.