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

How do you delete a data source?

0 Answers  

What are the types of normalization?

0 Answers  

What is meant by indexing?

0 Answers  

What is the maximum size of column in sql server?

0 Answers  

what is Covering Index ?

3 Answers   Thomson Reuters,




do views contain data ?

0 Answers   MCN Solutions,

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

Explain syntax for disabling triggers?

0 Answers  

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

What is blocking and how would you troubleshoot it? : sql server database administration

0 Answers  

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

How to view existing indexes on an given table using sys.indexes?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories