Answer Posted / gopi a
Stored Procedure is Precompiled set of quries. Stored
Procedure performence fully depended on this queries. First
Look the queries performence using Execution Plan. After
find the Queries, just check the Index(for table used in
query) and look the join conditions between tables in the
query. - This is way we need to approch to tune the SP.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is the default Port No on which SQL Server listens?
What are the new features of sql server 2012 reporting service?
Can I run multiple instances of sql server 2000 at the same time on one computer?
How to concatenate two binary strings together?
What are the Advantages of using CTE in sql server?
How does the report manager work in SSRS?
How to loop through result set objects using mssql_fetch_array()?
What is the recovery model?
Can we update data in a view?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
List the data types available in mssql?
How do you create a data source?
Explain syntax for viewing, dropping and disabling triggers?
How to transfer a table from one schema to another?
What is sql azure database?