You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
904What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
959On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
957Post New DB Development Questions
How can you fix a poorly performing query?
Explain about normal forms?
Explain the cube operator?
What are the constraints on severity level in raiseerror?
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?
explain detail about ftp in datastage?
Who are naive users?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
How to read and create .LDC data files which are used by linguatic dictionary.
What is dbms and its application?
Can an extended stored procedure be called from inside a user-defined function?
What are the key features of dbms?
What is the physical representation for a many-to-many relationship?
What is data modeling with example?
Explain what a database is?