How do you measure the performance of a stored procedure?
- 3 Answers
- 14800 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / vb
Execution time is fast
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a mixed extent?
How to truncate the log in sql server 2012? : sql server database administration
What are the requirements on sql server network connections?
How to get the number of affected rows?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How to disable stored procedure sql server?
How to check if a table is being used in sql server?
What is normalization? Explain different forms of normalization?
What is ddl and dml commands?
How to write a query with an inner join in ms sql server?
What is an indexed view?
Explain difference between control flow and data flow?
What do we need queues in sql service broker?
Will the writetext statement activate a trigger?
How are the unique and primary key constraints different?
