Interested to Buy Any Domain ? << Click Here >> for more details...
How do you measure the performance of a stored procedure?
- 3 Answers
- 16029 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / jayagopal p.s
Run the sp and check the response time of that sp.If it
takes a long time to response then optimize the query to
reduce the time usage.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the use of custom fields in report?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What do you know about normalization and de- normalization?
Explain what you mean by 3 tier architecture.
What is database black box testing?
What is the significance of master, tempdb and model databases?
Does index slows down insert statements?
What is the difference between sdf and mdf?
How do I find the sql server instance name?
What number sorts of privileges are accessible in sql?
What is sub query and its properties?
What is the difference between Stored Procedures and triggers?
Tell me about the approaches which you used to counter the DI problems.
What is the new security features added in sql server 2016? : sql server security
Can you insert NULL in unique column?
