You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
No Answer is Posted For this Question
Be the First to Post Answer
What is openrowset sql server?
What is page-level compression?
Explain the difference between clustered and non-clustered index?
Why do we use trigger?
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?
Define candidate key, alternate key, composite key.
13 Answers Infosys, Software India,
What are sub-queries? Give example? In which case sub-queries are not feasible?
Explain syntax for dropping triggers?
Tell me about builtinadministrator?
What are the purpose of Normalisation?
What is the importance of a recovery model?
How do triggers work?