Interested to Buy Any Domain ? << Click Here >> for more details...
How do you measure the performance of a stored procedure?
- 3 Answers
- 16193 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
How to install sql server 2005 express edition?
What is primary key and example?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is the difference between dbcc indexdefrag and dbcc reindex?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Explain hostprotectionattribute in sql server 2005?
What is the ‘fillfactor’?
What are cascading parameters in ssrs reports?
Define normalisation?
How to delete database objects with "drop" statements in ms sql server?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What is ddl command?
what are the different types of SSRS reports?
What is user-defined multi-statement table-valued function?
What are the types of processing and explain each? : sql server analysis services, ssas
