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
- 4314 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 |
How to query multiple tables jointly?
What is an identity?
Explain what is sql server english query?
What are the steps you will take, if you are tasked with securing an SQL Server?
Explain what is meant by replication of database?
What are ddl triggers and types of ddl trigger?
Explain rdbms?
Do you know what is fill factor and pad index?
What is user defined datatypes and when you should go for them?
what is difference between NULL and ISNULL in SQL Server 2008?
What is a join in sql?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
-
Oracle (3253) - 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)
