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

Post New Answer

More SQL Server Interview Questions

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  


What is a non-clustered index?

0 Answers  


Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,


What is the standby server?

0 Answers  


What are security principals used in sql server 2005?

0 Answers  






How many categories of functions based their return modes?

0 Answers  


What are the advantages dts has over bcp?

0 Answers  


How many clustered indexes there can be on table ?

0 Answers  


What is a linked server in sql server?

0 Answers  


What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  


How we can refresh the view?

0 Answers  


what is call by value & call by reference ?

2 Answers   Cap Gemini,


Categories