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

Explain the relational database management system (rdbms)?

0 Answers  


What number aggregate functions are accessible there in sql?

0 Answers  


Explain Capacity planning to create a database? and how to monitor it?

0 Answers  


What are the different types of collation sensitivity?

0 Answers  


Explain a join?

0 Answers  






Can we insert data into view sql server?

0 Answers  


mention different types of relationships in the dbms?

0 Answers  


List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  


Why is the need for data conversion transformations?

0 Answers  


Define inner join in sql server joins?

0 Answers  


what is the sql equivaent of the dataset relation object ?

0 Answers  


What are trace flags?

0 Answers  


Categories