Interested to Buy Any Domain ? << Click Here >> for more details...
what is performance tunning in sql server ? explain.
- 1 Answers
- 4793 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 |
What command do we use to rename a db?
Explain what are the restrictions while creating batches in sql server?
What is the difference between cross join and Full outer join?
Detail about the hardware which is supported by SQL server?
What are the magic tables in SQL Server 2000?
7 Answers Infogain, Merrill Lynch,
what are user defined datatypes and when you should go for them? : Sql server database administration
What are basics of policy management?
How to maintain a fill factor in existing indexes?
What methods do you follow to protect from sql injection attack?
What is the difference between the application object and session object?
Explain the properties of sub-query in sql server?
How do we return a record set from a Stored Procedure in SQl server 2000?
-
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)
