There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
Answer / swapna
Instantiating COM objects is a time consuming process and
since you are doing it from within a trigger, it slows down
the data insertion process. Same is the case with sending
emails from triggers.
This scenario can be better implemented by logging all the
necessary data into a separate table, and have a job which
periodically checks this table and does the needful.
Is This Answer Correct ? | 0 Yes | 0 No |
1 01 101 01010
What are the system database in sql server 2008?
Explain the difference between HTTP and HTTPS in database?
What are truncate options available in sql server? : sql server database administration
What is the difference between set and select?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Explain contrast amongst grouped and non-bunched records?
how would you troubleshoot blocking? : Sql server database administration
What do you mean by an execution plan?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How to defragment table indexes?
What is table value parameters (tvp)?