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 happens if the update subquery returns no rows in ms sql server?

1094

How many partitions a clustered index has by default in sql server 2012?

1059

How to attach adventureworkslt physical files to the server?

1069

role of sql sever 2005 in database rather than any other database

1906

What are the essential components of sql server service broker?

986

Explain where clause?

950

How can I change procedure name in sql server?

1002

Explain Normalization and DE normalization

1075

Explain the different index configurations a table can have?

914

Which is the main third-party tool used in sql server?

911

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1053

How to concatenate two strings in SQL Server.

1113

Is truncate a dml command?

903

is it important for a database administrator to understand the operating system and file access? : Sql server administration

992

What are the instances when triggers are appropriate?

946