What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
No Answer is Posted For this Question
Be the First to Post Answer
What are triggers? How many triggers you can have on a table?
Explain the general syntax for a SELECT statements covering all the options.
How can you log an error to the server event log from a stored procedure?
What are the three types of database design?
What are the three basic rules which are to be followed for the relational model of the database?
What is dbms explain in brief?
How to use online Backups?
What is the maximum length of an extended property?
Write short notes on XSU and JAVA
Explain about the database management systems.
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?
Can an extended stored procedure be called from inside a user-defined function?
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)