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 Self Join?
What are the recovery models for a database?
What is a View ? Can we insert, Update and delete a view?
what is isolation level at dead lock?
how many no of arguments can be passed in procedures and functions
What is the basic difference between clustered and a non-clustered index?
two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?
Diffrences between sql server 2000 vs 2008
How to call a function from a stored procedure in SQL Server ?
How many types of indexes are there in SQL Server?
ow to bring suspect mode datbase online from scratch
What is the New in SQL server 2008?