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|
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What are the hotfixes and patches in sql server?
what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?
Tell me what is normalization? Explain different forms of normalization?
Diffrence between DTS vs SSIS
Difference between Cluster and Non-cluster index?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What are the differences between UNION and JOINS?
When we should use and scope of @@identity?
Explain where clause?
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder
How cand Optimize SQL Server Stored Procedures