Interested to Buy Any Domain ? << Click Here >> for more details...
what is performance tunning in sql server ? explain.
- 1 Answers
- 4851 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer / karthikeyathirughanashamphanth
Step-1:Capturing Performance metrices.
Step-2:Find the problem Queries with Profiler.
Step-3:Define Mitigation for the Problem Queries.
| Is This Answer Correct ? | 1 Yes | 1 No |
Can you roll back the ddl statement in a trigger?
What is multilevel indexing?
Explain primary key, foreign key and unique key?
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
What is a document index?
can you any body tell me suppose database is suspect mode. how can take to normal?
Do you know what is sql service broker?
what is a transaction and what are acid properties? : Sql server database administration
Write a SQL query in order to merge two different columns into single column?
How you can find out if an index is useful to the optimizer?
What is the purpose of self join?
Explain foreign key in 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)
