how much do you have?

[Kornfeld Eliyahu Peter]

I found we use SQL triggers a bit too much... 336 triggers on 1450 tables... (~23%)

Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

[Slacker007]

We hardly use triggers at all. Interesting that you have more than 5. :doh:

[Lost User]

0 triggers on 0 tables (NaN%)

[megaadam]

You obviously need one table per trigger to keep track of them. Then add a trigger for each table if any trigger changes. FTFY.

... such stuff as dreams are made on

[Kornfeld Eliyahu Peter]

Isn't it 100%? :-)

Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

[Kornfeld Eliyahu Peter]

Actually some of the triggers are there to log data changes (on important tables)... Others are for data integrity... And others are for sync with externals...

Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

[Lost User]

Yes but it's also 42%, and 9001%, etc..

[ZurdoDev]

Kornfeld Eliyahu Peter wrote:

(~23%)

We got you beat. 247 triggers on 741 tables, exactly 1/3, although not intentional.

There are two kinds of people in the world: those who can extrapolate from incomplete data. There are only 10 types of people in the world, those who understand binary and those who don't.

[Lost User]

I avoid them as triggers too easily lend themselves to database-vendor specific code.

Installing Signature... Do not switch off your computer.

[Pualee]

I'd start looking for a new job before the house of cards falls down.

[CodeWraith]

My former bosses have about 10 - 15 triggers on each and every table, some of them thousands of lines long. A nightmare. Especially after that experience: 0.0 triggers per table and not a single trigger more.

I have lived with several Zen masters - all of them were cats.

[Kornfeld Eliyahu Peter]

That sounds awful... Our triggers are short (sometimes 2-3 triggers on the same event, just because they all do something else)...

Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

[CodeWraith]

The major part of the application logic took place in those triggers. Guess why I run out of job interviews when I hear 'Access' or ' Former Acess project that has ben ported to xxx'.

I have lived with several Zen masters - all of them were cats.

[abmv]

Lotta time I see...

Caveat Emptor. "Progress doesn't come from early risers – progress is made by lazy men looking for easier ways to do things." Lazarus Long

[Dave Kreskowiak]

I've used 2 in my entire 32 years of doing this crap.

System.ItDidntWorkException: Something didn't work as expected. A guide to posting questions on CodeProject

Click this: Asking questions is a skill. Seriously, do it.
Dave Kreskowiak

[megaadam]

Sounds like a bunch of trigger happy bosses :suss:

... such stuff as dreams are made on

[R Giskard Reventlov]

Zero. Who needs 'em, eh?

[Kornfeld Eliyahu Peter]

Working on a review of the DB design to suggest improvements...

Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

[Slacker007]

CodeWraith wrote:

My former bosses

Database guys in charge of application development? Sounds like it to me.

[PIEBALDconsult]

Zero. Though I may have written one about ten years ago. Only as a convenience for debugging. It was not vital to the system.