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?
905What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
960On 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?
959Post New DB Development Questions
What is database design and development?
Can an extended stored procedure be called from inside a user-defined function?
Which data type cannot be used as a parameter in a udf?
How can you fix a poorly performing query?
Explain the role of indexing in databases?
What is the maximum length of an extended property?
What is the physical representation for a many-to-many relationship?
How to combine two function together?
What is normalization? Explain different levels of normalization?
What is dbms explain in brief?
What is DB Development software?
How to generate OIDS
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
How can you log an error to the server event log from a stored procedure?
Explain about relational database management systems?