[AccessD] OT: The Great Primary Debate

jwcolby jwcolby at colbyconsulting.com
Tue Jun 1 19:58:23 CDT 2004


Nearly 60 makes you an old fart.  Being on the side of autonumbers makes
you an old fart with good sense.

;-)

John W. Colby 
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Tuesday, June 01, 2004 8:41 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] OT: The Great Primary Debate


Hey, I'm nearly 60.  And I'm on the side of autonumbers!  I'm not sure
what that makes me ... Confused?

Charlotte Foust

-----Original Message-----
From: jwcolby [mailto:jwcolby at colbyconsulting.com] 
Sent: Tuesday, June 01, 2004 4:22 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] OT: The Great Primary Debate


So... At 49 years old, would I qualify as one of the younger developers
or one of the older?  ;-)

John W. Colby 
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Tuesday, June 01, 2004 2:17 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] OT: The Great Primary Debate


I was taking day one of a 4 day Programming SQL Server 2000 course
today. 8 Oracle programmers moving to SQL Server, 6 of our Ingres
programmers moving to SQL Server.

Came to the section on Table Design. I said use an Identity value for
the PK on the table - all h%ll brooke loose for the next hour as the
great debate happened live in person. Pity JC wasnt there to back me up
(<: Was split between the younger developers who supported the use of
the ID column and the older developers and DBAs who use natural keys.
Almost a 50//50 split on age lines maybe reflecting different attitutes
to design. Took me about 20mins with one of the older guys to explain
how the relationship was maintained using Idt IDs as opposed to his
staff number. He seemed to have real problems getting the concept.

Martin


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list