About autonumber
-
Hello sql gurus!
I have an autonumber field called memberID and the field is also the primary key. Now, when a user wants to delete his account there becomes a gap! Doesn't this "damage" the indexation (hmm... is that a correct term?)? Well, if it does... How can I fill these gaps? Does anyone have any experience with this?
-
No, it does not. In any event you can run DBCC CHECKIDENT every now and then to make sure everything is as it should (See DBCC CHECKIDENT for a more detail explanation.)
Set this step as one of your regular maintnance tasks and everything will work fine. Good luck
-
Totally agree. The gaps are fine. In extreme cases (financial records maybe) where you must preserve the numbers, you can added a deleted column - just have to remember to exclude it from every operation. Or put them in a separate table for research purposes.
Andy
-
thanks!
-
oh... and how often is "every now and then"? Everytime a member registers?
-
Hardly ever. In my experience they are very reliable, I'd at most you need to run after a bad shutdown or as part of a monthly mainteance routine.
Andy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply