How do you measure the performance of a stored procedure?

Answer Posted / vb

Execution time is fast

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is surrogate key? : sql server analysis services, ssas

699


Explain difference between cross join and full outer join?

561


You want to implement the one-to-many relationship while designing tables. How would you do it?

508


Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

515


Can a database be shrunk with users active?

607






If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

538


What is partition in sql server?

533


Can group by and orderby be used together?

597


What is compound operators?

552


How to select some specific columns from a table in a query in ms sql server?

505


How to loop through the result set with @@fetch_status?

669


Difference between report and query parameter.

600


Explain transaction isolation levels in sql server?

551


What are temporal tables in sql server 2016?

479


How do you size a resultset?

502