Check the some step 1. Space in HD 2. Use DBCC FREEPROCCACHE & DBCC

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

Question Posted / rajan chauhan

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What are the extra roles available in msdb? : sql server security

1183

What are user-defined functions (udfs) in sql server?

1051

What are the lambda triggers?

960

How to delete existing triggers using "drop trigger"?

1105

What is the current limitation of the size of SQL Azure DB?

129

What is trace flag in sql server?

1082

Tell me what is the difference between locking and multi-versioning?

1089

Can we shrink data file in sql server?

1097

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

1018

What do you understand by sql server agent?

1030

What is sql injection? How to protect against sql injection attack?

1045

Explain the various types of concurrency problem?

1246

What is the main purpose of having conversation group?

958

Explain transaction server isolation?

1085

What is field with example?

978