Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps you will take to improve performance of a
poor performing query?
- 1 Answers
- 4673 Views
- I also Faced
- E-Mail Answers
Answer Posted / m.sivakumar
Some general issues that you could talk about would be:
No indexes,
table scans,
missing or out of date statistics,
blocking, excess recompilations of stored procedures,
procedures and triggers without SET NOCOUNT ON,
poorly written query with unnecessarily complicated joins,
too much normalization, excess usage of cursors and temporary
tables.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is a livelock?
What do you mean by a dependent functionality in a build?
What are the two modes of authentication in sql server?
Can you explain what are various ways to enhance the ssrs report?
How to create new tables with "select ... Into" statements in ms sql server?
Define self join in sql server joins?
What are the differences between union, intersect, and minus operators?
What is proper subset of candidate key?
How many instances per computer are there in sql server 2000?
What is Replication?
how to invoke a trigger on demand? : Sql server database administration
How to get @@error and @@rowcount at the same time?
Can you always create a cache of a report?
What part does database design plays a role in performance of an sql server-based application?
