Re: simple delete statement runs forever

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 12:44:43 -0500

I was waiting for that. ;-) 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message 
news:emED33nFEHA.3032@TK2MSFTNGP09.phx.gbl...
Triggers and cursors both have their place, however.

Relevant Pages

  • Re: Why does this trigger recompile frequently?
    ... Cursors in triggers are a really bad idea. ... logic is contained in the Trasp002 proc into the trigger. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Indirect use of cursors
    ... 9iR1 database has been caused by the recent introduction of some PL/SQL ... The triggers typically fire on insert and/or update, ... but there's zero use of cursors as I understand ...
    (comp.databases.oracle.misc)
  • Re: for updae trigger question
    ... I will try to generate the triggers that way so the ... >> Rather than write dynamic SQL into your production code why not write ... >> David Portas ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: OUTPUT INTO clause
    ... The main gotchas come from the use of triggers on the tables or the ... SQL Server MVP ... SELECT t1_id, col2 ...
    (microsoft.public.sqlserver.programming)
  • Re: Triggers, performance, and distributed processing
    ... > Yes, we really like the concept of triggers, and are reluctant to use ... > alternatives to cursors. ... the data is an exact copy of production. ... David G. ...
    (microsoft.public.sqlserver.server)