Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the different authentication modes in sql server? How can it be changed?
List the different types of joins?
Why Master database is required?
Can two different columns be merged into single column? Show practically?
Mention a few common trace flags used with sql server?
How to provide values to stored procedure parameters in ms sql server?
How to assign new column names in a view?
Explain tables in SQL Azure?
Write a code to select distinct records without using the DISTINCT keyword.
What is change tracking in sql server?
What is not null constraint?
When would you use sql joins?
How do I find the sql server version?
How can you manage sql azure security?
What are the advantages of the mirroring?
