For some reason our site generates about 20,000 anon customer ID's a week. We keep the numbers down by running a maintenance script to purge the ID's twice a week.
Our SQL customer numbers have grown rapidly, almost a million since Christmas. What I am wondering is is there a way to somehow use the old customer ID's? Not that we are going to run out any time soon but we have looked at every way of why this is happening but have found no logic behind it.
It seems a bit strange that we delete around 100,000 SQL rows from our customer dbo but cannot re-use them again. If anyone does know of a way I would be grateful.
I would invest some time and efforts in identifying the reason for the rogue id's being generated (using SQL Trace, for example). That would cure the problem at the root.
If you do want to reuse the id's, (and here I am assuming you are referring to identity columns), there are ways to do it - See Peter Larsson's article here: http://www.sqlteam.com/article/efficiently-reuse-gaps-in-an-identity-column If you do want to try evaluate the impact on business rules and other queries/code. Also, I have not tried the method described there, but usually Peter's articles are well thought out