Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / arun yadav
There could be 'n' reasons for slow performance. For tuning
the performance of a SP we need to know how much resources
it is using and how much time it takes in execution. We can
check this using the performance monitor (for example, RPC
Counter) and execution plan. Check if we are using
appropriate joins, table defrag, index rebuilt can be the
solutions.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What does <> symbol mean?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Is the primary key column of a table an index in ms sql server?
What is tablix?
How do we know if any query is retrieving a large amount of data or very little data?
Explain the properties of the relational tables?
What is sql server english query?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
List all the types of user-defined functions?
What is ms sql server service broker?
What are the transaction properties?
Difference between uniqe index and uniqe constraint?
How do I view a script in sql server?
what is dbcc? : Sql server database administration
How to create a view on an existing table in ms sql server?
