Re: Use top value in a query

Tech-Archive recommends: Fix windows errors by optimizing your registry


"Jamie Collins" <jamiecollins@xxxxxxxxxx> wrote in message
news:1158315299.317775.164810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Baz wrote:
Correlated subqueries are, of course, a performance disaster in Access.

The OP will doubtless make up his own mind whether he is bothered about
proprietary syntax. Personally I couldn't care less.

You remind me of this :)

'I Will Never Have To Port This Code': Debunking shortcuts and SQL
myths
By Joe Celko
http://www.intelligententerprise.com/030422/607celko1_1.jhtml

"If you hang around the database developer newsgroups, you'll find
rookie programmers who write their code with proprietary features of
whatever SQL product they have. They argue that they'll never have to
port this code, so why bother to write standard SQL when you can gain
some advantage in performance with a proprietary feature?"

Jamie.

--


I'm familiar with Celko's pompous utterings, he sprang to my mind when I saw
your original post ;-). However, unlike Celko, this rookie programmer lives
in the real world (and has been doing so for all his 23 years of developing
database systems). One thing that I have seen many times over those decades
is IT purists on a mission who spend huge quantities of their employers'
money chasing theoretical ideals whilst users get ever more frustrated
because nothing ever gets delivered. This generally leads to the users
hacking their own systems together piecemeal in Excel or Access, so the
purists' determination to construct the world's most beautiful systems
actually results in the complete opposite. And invariably they all
eventually get sacked when the company gets fed up with pouring dosh into
the IT department's bottomless pit.



.

Relevant Pages

  • Re: Come on MVPs I need your help
    ... Its funny, I cant remember being rude to you rather the opposite, never mind ... without the need to tell us not to bother posting. ... > my comp icon or try to access my drives. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Come on MVPs I need your help
    ... without the need to tell us not to bother posting. ... >>> your piece of mind there is nothing other than access to my various ... >>> my comp icon or try to access my drives. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Accessing SQl files by a RPG program or something else ?
    ... I don't mind you recommending a non-IBM solution to the problem. ... DB2 Connect does not support the access of SQL Server tables, ... known as the SQL Call Level Interface, ...
    (comp.sys.ibm.as400.misc)
  • Re: Is SQL a good language for this problem ?
    ... even using an SQL DBMS at all since they would be getting no value and lot ... and dynamically construct your queries using its metadata. ... I'm sorry, I think I don't know enough to follow you here, would you mind ... feature of all the SQL products out there. ...
    (comp.databases)
  • Re: Perfect Mental Control for Perfect Sight
    ... Why bother. ... You say you are not bothered about what is going thru my mind but it ... you have a habit of projecting your opinion. ... This list is not a science list for scientists. ...
    (sci.med.vision)