Re: What's wrong with triggers?


Tony Rogerson wrote:

> Aside from the portability stuff there is nothing wrong with them at all.

Tony,
I think Celko describes a widely held position i.e. if there is a
Standard SQL alternative to a trigger (e.g. CHECK, CREATE ASSERTION,
etc) then use it, if your product supports the SQL/PSM then much the
better, etc. I'd wager Celko uses triggers all the time e.g. from
comments such as, 'Now start hiding this in VIEWs with INSTEAD OF
triggers'.

I must respectfully disagree with the comments you have been making
recently, Tony, and say that I do think Celko does operate in the real
world. I deduce that he does not want to advocate using proprietary
features until the equivalent Standard approaches have been discounted.
This is certainly the methodology I use.

Sometimes his brusque approach makes me cringe but more often than not
he hits the sweet spot for me.

Jamie.

--

.

Relevant Pages

  • Re: Whats wrong with triggers?
    ... like data auditing, I've used triggers a lot when a client needs full data ... position on celko is clear and unless he changes his bad attitude and ... Tony Rogerson ...
    (comp.databases)
  • Re: Celko never responds when challenged by Tony, why?
    ... something....then Celko never responds. ... challenged by Tony where he compared the performance and said that it ... Because POMPUS A$$ authors never reply to direct questions. ...
    (microsoft.public.sqlserver.programming)
  • Celko never responds when challenged by Tony, why?
    ... I noticed that in almost all of the postings (Celko vs Tony), ... (Like the 1000 parameter solution by Celko that was ...
    (microsoft.public.sqlserver.programming)
  • Re: Celko never responds when challenged by Tony, why?
    ... something....then Celko never responds. ... (Like the 1000 parameter solution by Celko that was ... challenged by Tony where he compared the performance and said that it ... Tony is not alone - when I prove Celko wrong, ...
    (microsoft.public.sqlserver.programming)
  • Re: Celko never responds when challenged by Tony, why?
    ... Still waiting to hear what Celko would implement as a primary ... key for Amazon's customers table. ... challenged by Tony where he compared the performance and said that it ...
    (microsoft.public.sqlserver.programming)