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?
1021What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
1078On 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?
1058Post New DB Development Questions
What is the maximum length of an extended property?
What is the database development process?
What are data modelling techniques?
On 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?
fact table and dimension table containg one to many relationship or many to one relastionship
Which data type cannot be used as a parameter in a udf?
What are the key features of dbms?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are the 18 schemas?
In which table collections errors are stored.
What are the constraints on severity level in raiseerror?
What is dbms and its application?
What are the three types of database design?
Explain what a database is?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?