Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 4232 Views
- I also Faced
- E-Mail Answers
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 |
List out the differences between global and local temp tables in sql server?
Explain the ways to controlling cursor behavior?
How to modify the underlying query of an existing view?
What does it mean to normalize data?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What do you mean by a dependent functionality in a build?
Explain basic SQL queries with SELECT from where Order By, Group By-Having?
How to create a dynamic cursor with the dynamic option?
What is a functions and types in sql server?
What are ddl (data definition language) statements for tables in ms sql server?
What are the requirements for sql server 2016?
how do u find least salary in a table
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
