Re: Row Order

From: Joe Celko (jcelko212_at_earthlink.net)
Date: 11/02/04 

Date: Tue, 02 Nov 2004 11:51:47 -0800

>> Okay, the truth is that I see the world in terms of sequential I/O.
Don't laugh - this is progress for me - I just graduated from seeing it
in terms of punch cards. I'm just trying to emplement a punch card
database that was morphed into a flat-file design into SQL Server. <<

Well, at least you know you have a problem; a lot of the people who post
here are working with the same mental models and don't know it. That is
the reason I beat people over the head about "file vs table", "row vs
record" and "column vs field"

My rule of thumb is that you have to be a full-time SQL programmer for
one full year before you can expect to have your satori and recieve
enlightenment. In the meantime, look at good code and read a lot.

--CELKO--
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are. Sample data is also a good idea, along with clear
specifications.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Row Order
    ... I guess my sarcasm wasn't as transparent as I thought... ... > in terms of punch cards. ... I'm just trying to emplement a punch card ... > Please post DDL, so that people do not have to guess what the keys, ...
    (microsoft.public.sqlserver.programming)
  • Re: How to get the 0 counts in a group by ?
    ... Please post DDL, so that people do not have to guess what the keys, ... As an aside until I know the DDL, the use of Boolean flags is usually a ... sign of a poor schema design. ... punch cards; the status of the flag is better computed with the base ...
    (microsoft.public.sqlserver.programming)