Sign Up Login


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

What are the steps need to be take improve the speed of a SQLDATA Server?

Question Posted / vijeesh.plr

Answers were Sorted based on User's Feedback



What are the steps need to be take improve the speed of a SQLDATA Server?..

Answer / dhiraj

Cover Index can Improve ..... SQLDATA SERVER -

Is This Answer Correct ?    2 Yes 0 No

What are the steps need to be take improve the speed of a SQLDATA Server?..

Answer / rajan chauhan

Check the some step
1. Space in HD
2. Use DBCC FREEPROCCACHE & DBCC DROPCLEANBUFFER
3. Cover Index

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is update_statistics command?

0 Answers  

How to enter comments in transact-sql statements?

0 Answers  

Do you know what is a trace frag? Where do we use it?

0 Answers  

When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

What is lock escalation? : sql server database administration

0 Answers  




How to execute stored procedure and set temp table in sql server?

0 Answers  

What is difference between sql and sql server?

0 Answers  

How to generate create table script on an existing table in ms sql server?

0 Answers  

What is raiseerror? What is raiseerror?

0 Answers  

What are the different types of collation sensitivity in sql server?

0 Answers  

What is the difference between insensitive and scroll cursor?

0 Answers  

Explain alternate key, candidate key and composite key in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories