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?
953What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
1002On 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?
995Post New DB Development Questions
In which database can extended stored procedures be added?
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
Explain what a database is?
How can I detect whether a given connection is blocked?
What are the 18 schemas?
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?
In which table collections errors are stored.
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Explain about normal forms?
Explain the role of indexing in databases?
Which data type cannot be used as a parameter in a udf?
State the acid rules?
How can you fix a poorly performing query?
How can you log an error to the server event log from a stored procedure?
What are the constraints on severity level in raiseerror?