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 |
Give the query of getting last two records from the table in SQL SERVER?
0 Answers Petranics Solutions,
What are the features of Embedded SQL
Explain the various types of concurrency problem?
Does partitioning ssd reduce performance?
Is sql server 2016 free?
what is sql server? : Sql server database administration
Can we add our custom code in ssis?
Can a rule be bound to any column of any data type?
What are the advantages of stored procedure in sql server?
How to change the ownership of a schema in ms sql server?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
Is the order of columns in the set clause important in ms sql server?
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)