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 failover clustering overview?
Does partitioning improve performance sql server?
Other than truncate statement, which other command can by-pass the trigger on the tables?
List some major differences between triggers and stored procedures?
How to create a trigger for insert only?
What are the parts of a function?
What is delete query?
What are sql server functions?
can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
SQL Server Performance Tuning for Stored Procedures & reducing debugging time?
1 Answers CarrizalSoft Technologies,
What is dml command?
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)