[dba-Tech] falsehoods programmers believe about names

Jim Lawrence accessd at shaw.ca
Tue Sep 26 14:26:49 CDT 2017


Of course Martin...how could I possibly forget. ;-)

Jim 

----- Original Message -----
From: "Martin Reid" <mwp.reid at qub.ac.uk>
To: "Discussion of Hardware and Software issues" <dba-tech at databaseadvisors.com>
Sent: Tuesday, September 26, 2017 12:24:11 PM
Subject: Re: [dba-Tech] falsehoods programmers believe about names

Don't forget auto number pk 😃
Martin

Sent from my Windows Phone
________________________________
From: Jim Lawrence<mailto:accessd at shaw.ca>
Sent: ‎26/‎09/‎2017 20:21
To: Discussion of Hardware and Software issues<mailto:dba-tech at databaseadvisors.com>
Subject: Re: [dba-Tech] falsehoods programmers believe about names

Hi Peter

That is why, in a database, I have never made a "name" the major key. IMO, names should be indexed for search purposes only, a soundex field can be helpful for handling strange name spelling variation and that is all. Student codes, SIN values, ZIP/postal codes and even phone numbers make better keys.

Jim

----- Original Message -----
From: "peter brawley" <peter.brawley at earthlink.net>
To: "Discussion of Hardware and Software issues" <dba-tech at databaseadvisors.com>
Sent: Monday, September 25, 2017 9:43:55 AM
Subject: [dba-Tech] falsehoods programmers believe about names

http://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/

PB
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com



More information about the dba-Tech mailing list