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?
964What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
1017On 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?
1001Post New DB Development Questions
How would you design a database for an online site, which would average a million hits a day?
Explain about the hierarchical model of the database?
Explain about post-relational databases?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Which data type cannot be used as a parameter in a udf?
Explain the rollup operator?
What is normalization? Explain different levels of normalization?
What is the physical representation for a many-to-many relationship?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
How long can an error message be in raiseerror function?
fact table and dimension table containg one to many relationship or many to one relastionship
How you can make a parameterized view?
Explain about the storage and physical database design?
In which table collections errors are stored.
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?