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 |
Explain the different types of backups available in sql server? : sql server database administration
What will be query used to get the list of triggers in a database?
Mention the differences between having and where clause.
what is mean by constraints in sql?
What is the use of keyword with encryption. Create a store procedure with encryption?
What is the difference between mysql and mysqli?
What Is The Difference Between Primary Key & Super Key
What is bit data type? What's the information that can be stored inside a bit column?
optimization techinques
How do I install only the client tools of sql server 2000?
What is a raid and what are different types of raid configurations?
Is BCNF better than 2NF & 3NF? Why?
0 Answers Akamai Technologies,
Oracle (3259)
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)