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
- 10249 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
How to declare and use cursor variables?
What are the essential components of sql server service broker?
How retrieve field names from the table in SQL through JAVA code?
How to delete all rows with truncate table statement in ms sql server?
How many types of objects are there?
Is natural join and equi join same?
How do I save a stored procedure in sql server?
What is the difference between a local and a global temporary table?
What the different topologies in which replication can be configured?
What is importing utility?
What is the difference between a function and a trigger?
What is normalization? Explain different forms of normalization?
What are Spatial data types in SQL Server 2008
Why is replication required on the sql server?
How to select an exiting database using mssql_select_db()?
