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 what is the use of custom fields in report?

0 Answers  

Without Using Cursors , How to Select the Selected row??

3 Answers   CarrizalSoft Technologies, Wipro,

What is the difference RDBMS and Graph Database?

0 Answers   EXL,

Explain system functions or built-in functions? What are different types of system functions?

0 Answers  

Can we perform backup restore operation on tempdb? : sql server database administration

0 Answers  




What is the purpose of a table?

0 Answers  

your distribution database is full what will u do

0 Answers  

Explain timestamp datatype?

0 Answers  

Do you know what is blocking?

0 Answers  

Do you know the isolation level that sql server support?

0 Answers  

Explain the concepts and capabilities of sql server?

0 Answers  

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories