1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are the steps you will take to improve performance of
a poor performing query?

Question Posted / swapna


What are the steps you will take to improve performance of a poor performing query?..

Answer / 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

More SQL Server Interview Questions

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

Which institute is best for SQL Server 2005 Training?

6 Answers  

What is raid, and how it can influence database performance?

0 Answers  

How can you check the version of sql server?

0 Answers  

What are the different types of collation sensitivity?

0 Answers  




What are different types of schemas?

0 Answers  

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

What are the main differences between #temp tables and @table variables and which one is preferred?

0 Answers  

What is function of CUBE ?

0 Answers   HCL,

What is data block and how to define data block size?

0 Answers  

What is the usage of the sign function?

0 Answers  

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories