[dba-SQLServer] PK/ANPK Debate

Susan Harkins ssharkins at gmail.com
Tue Mar 11 05:52:20 CDT 2014


Me too. :)

On Tue, Mar 11, 2014 at 12:39 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote:
> I ALWAYS start EVERY table design with an autonumber PK.  Even when it makes
> no sense - like I'll never be doing a sort or find on this table.  Still -
> just a habit - but I think it's a good one. I don't EVER have to think about
> the consequences of picking a non-autonumber primary key.
>
> As the philosopher says: "No brains, no headache."
>


More information about the dba-SQLServer mailing list