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
- 10339 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / swapna
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.
Some of the tools/ways that help you troubleshooting
performance problems are: SET SHOWPLAN_ALL ON, SET
SHOWPLAN_TEXT ON, SET STATISTICS IO ON, SQL Server
Profiler, Windows NT /2000 Performance monitor, Graphical
execution plan in Query Analyzer.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Difference between report and query parameter. Why do we need different type of parameter?
Tell me what is sql profiler?
Why use triggers?
What do you understand by hotfixes and patches in sql server?
Can two tables share the same primary key?
Tell me what is normalization? Explain different forms of normalization?
What are the drawbacks of reporting in ssrs?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the difference between a unique key and primary key?
How can I create a report based on a query? : sql server management studio
how can u get last observation in an unknown dataset ?
Explain about link server in sql server?
What is the difference between delete and truncate statements?
Explain the steps to create and execute a user-defined function in the sql server?
User wants only to display only pdf as export option in report manager. How to achieve this?
