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 Posted / 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 |
Post New Answer View All Answers
What are different types of database indexes?
Why variables called the most powerful component of ssis?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is difference between oltp and olap?
What is a trace frag? Where do we use it?
What is an etl file?
What are the advantages of the mirroring?
What is linked report?
What is openrowset sql server?
What is difference between unique and primary key?
Find nth lowest salary or get nth lowest salary?
can any body tell me how to know the password of current user in sql server
do views contain data ?
What are the reporting services components?
Explain “row_number()” in sql server with an example?