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
- 5222 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 is Transparent Data Encryption?
Explain multiserver query
What guidelines should be followed to help minimize deadlocks?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
what are the new features introduced in sql server 2000? : Sql server database administration
MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
If we delete pack Spec what will be the status of pack Body ?
What are the character string functions supported by sql server 2005?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is partition index in sql server?
We need to perform what steps in the following order to work with a cursor?
-
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)
