Interested to Buy Any Domain ? << Click Here >> for more details...
what is performance tunning in sql server ? explain.
- 1 Answers
- 4775 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between clustered and a non-clustered index?
What is service broker?
Explain different types of index?
How to rebuild master databse?
List few advantages of stored procedure.
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is a derived table?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
How do you set a trace flag in sql server?
How would you use user_constraints table in DB?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What is clustered index
Which sql server table is used to hold the stored procedure script?
What protocol does sql server use?
how many triggers you can have on a table? : Sql server database administration
