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

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,


How to concatenate two strings in SQL Server.

0 Answers   HCL,


Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,


Which joins are sql server default?

0 Answers  


Describe in brief system database.

0 Answers  






What is in place upgrade in sql server?

0 Answers  


Can we do dml on views?

0 Answers  


Explain few examples of RDBMS?

0 Answers   Wipro,


can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 Answers  


What are the restraints imposed on the table design by a merge replication?

0 Answers  


How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,


How many null values we can have in a unique key field in sql server?

0 Answers  


Categories