Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps need to be take improve the speed of a SQLDATA Server?
- 2 Answers
- 5105 Views
- IBM, I also Faced
- E-Mail Answers
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 are various aggregate functions that are available?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
How to get nth highest salary from employee table.
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is query cost in sql server?
What is the cartesian product of table?
How to delete existing triggers using "drop trigger"?
Explain some stored procedure creating best practices or guidelines?
what is normalization? Explain different levels of normalization? : Sql server database administration
How do I find the sql server version?
How does index makes search faster?
-
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)
