What are the steps need to be take improve the speed of a SQLDATA Server?
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 |
Post New Answer View All Answers
How do I perform an unattended install of sql server 2000?
what is a correlated sub-query? : Sql server database administration
What is data modeling and Reterminal integrity?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is nolock?
What is coalesce and check constraint in sql server?
Does transparent data encryption provide encryption when transmitting data across the network?
What are differences in between sql server 2012 and sql server 2016?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
Can we use max in where clause?
What is the main difference between ‘between’ and ‘in’ condition operators?
List some case manipulation functions in sql?
What are tables in sql server?
How to remove duplicate rows from table?
What are the disadvantages of indexes?