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 |
Introduction of rollup clause using sum and group by clause?
What is a ddl statement?
What is scrollable cursor?
How make remote connection in database?
How important do you consider cursors or while loops for a transactional database?
How to retrieve data from log files in SQL SERVER ?????
what is isolation level at dead lock?
Explain transaction server explicit transaction?
What is a functions and types in sql server?
What is the datatype of rowid?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What is the security principal at the server level that represents your session?
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)