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
- 10146 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
What is the report builder?
Can we insert data into a view?
What is a partitioned view?
What different steps will a sql server developer take to secure sql server?
How to populate a table in sql server?
How many full-text indexes can a table have?
How to apply filtering criteria at group level with the having clause in ms sql server?
What is normalization 1nf 2nf 3nf?
What is data set in report?
Explain identity in sql server?
How do clustered indexes store data?
What is the security model used in sql server 2005?
What is transact-sql language?
What are the tool windows in sql server management studio? : sql server management studio
What is dirty page?
