Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bala17582
Starting Member
5 Posts |
 Posted - 2004-09-22 : 18:44:57
|
Does a trigger reduce the system performance. Could Any one give me a classic real time example for a trigger  Better Late Than Never Bala |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-09-22 : 18:49:01
|
| http://www.sql-server-performance.com/trigger_tuning.asphttp://msdn.microsoft.com/msdnmag/issues/03/12/DataPoints/default.aspx |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-22 : 18:59:13
|
| More homework questions?Tara |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-09-22 : 19:20:16
|
| I had this same question on my homework, too. here's what I used, I got an A+. Just cut and paste for your answer:A trigger is derived from OLAP processing constructs allowing distinct replicatable constraints, thereby allowing the pre-processor to classify non-ANSI kernel calls into hierarical persistant data structures. A classic example is a polymorphic interface which deploys boolean XML documents enabling real-time multi-tiered decompileable procedure calls.Let me know how you do !- Jeff |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-23 : 05:34:55
|
ROTFL!!!! that's why they call you Dr.  Go with the flow & have fun! Else fight the flow  |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-09-23 : 09:58:19
|
quote:
Originally posted by tduggan
More homework questions?Tara
More likely an interview question...Who has time for school?Brett8-) |
|
|
|
|
|
|
trigger