How do you measure the performance of a stored procedure?
- 3 Answers
- 15261 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / balaji l
Run the query execution plan if the sp is optimized or not.
Optimize the query if it takes more time. Check the cpu i/o
time usage.
| Is This Answer Correct ? | 13 Yes | 7 No |
Post New Answer View All Answers
Why would you call update statistics?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Describe how to use the linked server?
What is bcp? When does it used?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
Difference between DELETE and TRUNCATE?
What are the different kinds of ssrs reports?
How you can get a list of all the table constraints in a database? : Sql server administration
Differentiate between SQL and ORACLE joins and write their syntax.
What is merge statement?
what data regions are and what are the different data regions?
What are number line correlation administrators will use while working with a subquery?
What is a functions and types in sql server?
What are the advantages dts has over bcp?
How to encrypt data between dialogs?
