Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / kum anshu


you want to be sure that queries in a database always execute at the maximum possible speed. To achi..

Answer / Gyanendra Pratap Singh

Ensuring proper maintenance of the database, including regular optimization of query plans, is essential. This can be achieved through the creation and maintenance of appropriate indexes.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is difference between after and before?

1 Answers  

How do you delete duplicate rows in sql server?

1 Answers  

What are the recovery models for a database?

1 Answers  

How you can move data or databases between servers and databases in sql server?

1 Answers  

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

What is a field name?

1 Answers  

What is a non clustered primary key?

1 Answers  

How to create indexed view?

1 Answers  

what authentication modes does sql server support? : Sql server database administration

1 Answers  

What are indexers?

1 Answers  

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

Explain external key management in sql server 2008

1 Answers  

For more SQL Server Interview Questions Click Here
Categories