Re: Autonumber Fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

> Using IDENTITY and AutoNumber as PK defeats the purpose of PK, this
> is not so bad in SQL Server as it allows you to choose something more
> sensible if you have an IDENTITY field in use as PK.


When I wrote that it defeats the purpose of the PK it should have read it
defeats the purpose of clustering on the PK unless the creation order is the
one you want to physically order your records.

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited
"Craig Alexander Morrison" <designers@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:u$06LmEwFHA.2924@xxxxxxxxxxxxxxxxxxxxxxx


.

Relevant Pages

  • Re: Can you remove default header when sending url link?
    ... Wes ... >>> sending or receiving certain types of file attachments. ... but that defeats the purpose of the Send the Link button. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Active Sync logic
    ... But I also think it defeats the ... entered in the PC or the PDA. ... >> I am frustrated with the logic of Active Sync. ... >> purpose of being automated. ...
    (microsoft.public.pocketpc.wireless)
  • Re: Can you remove default header when sending url link?
    ... >> sending or receiving certain types of file attachments. ... but that defeats the purpose of the Send the Link button. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: 40% slowdown with dynamic /bin/sh
    ... You dislike the dynamic root decision enough that ... you make a sarcastic remark. ... defeats the purpose of running FreeBSD for me. ...
    (freebsd-current)