|
|
Posted by teddysnips on 08/20/07 11:03
On Aug 18, 2:37 pm, Gert-Jan Strik <so...@toomuchspamalready.nl>
wrote:
> Well, maybe someone did a large insert (of thousands of rows) and
> cancelled the insert during operation.
Under normal operation of the system this is completely impossible. I
cannot, however, guarantee that this was not done maliciously.
> Anyway, IMO an Identity column is a very poor idea if you really need a
> sequence without gaps. Identity columns are simply not meant to do that.
> If that is what you want, then I would remove the Identity property and
> determine the sequence number myself (using a reliable method).
>
> If the Identity column is simply used to generate a unique meaningless
> surrogate key, then I wouldn't worry about gaps, and would attempt to
> analyze it either...
The presence of a gap is not important - the purpose of the Identity
column is purely for purposes of providing a unique number for the
record. However, the presence of the gap IS important because there
are other problems with databases on this server and makes me think
that there's something seriously amiss.
Edward
Navigation:
[Reply to this message]
|