Hi guys,
I have a column that use identity column, and the table includes this column
is heavily used for insert and delete. The value of this column gradually
increase very big and I am fraid it will be overflowed in the future. I know
the truncate statement can do it, but it cannot be satisfed to my need. Is
there any other way that can make this value to be lower. Thanks.

Clustered Index Not Working
Select distinct problems
Top 1 query problem
How to compare two tables of same structure using a hash/checksum
SELECT/INSERT SELECT performance issue