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 are the grouping functions?
What is the difference between ddl and dml?
What's the information that can be stored inside a bit column?
What is meant by indexing files?
What is the difference between index seek vs. Index scan?
Is it possible to create trigger on views?
What are the steps to insert a table?
wat is the main diff between sql server 2000and sql server 2005
Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0
7 Answers PMAM IT Services, TCS,
Which virtual table does a trigger use?
what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?
What are the different types of sql server replication? : sql server replication
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)