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? : Sql server administration


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,


what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  


How to tune a stored procedure?

6 Answers  


Does sql server 2000 clustering support load balancing?

0 Answers  


What are different types of statement?

0 Answers  






The Difference between 'Count' and 'Count(*)'

13 Answers  


What is the difference between mysql and sql server?

0 Answers  


Can a table have 2 primary keys?

0 Answers  


Is truncate autocommit?

0 Answers  


What is global temp table?

0 Answers  


Scalability, Availability, Integration with internet, etc.)?

0 Answers  


What is sql injection? How to protect against sql injection attack?

0 Answers  


Categories