What are the steps need to be take improve the speed of a SQLDATA Server?
Answers were Sorted based on User's Feedback
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 |
What is sub-query in sql server?
Explain about SQLOS?
What is purpose of normalization?
what is an sql server?
How to check parameter value in stored procedure sql server?
What is bit data type?
How to delete a login name in ms sql server?
Define Joins?
How to sort query output in descending order in ms sql server?
What are the differences between sql server and mysql.
What is a trigger?
what is the information that can be stored inside a bit column? : Sql server database administration
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)