Sign Up Login


  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 / m.sivakumar


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

Answer / m.sivakumar

Some general issues that you could talk about would be:

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.

Is This Answer Correct ?    8 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How does using a separate hard drive for several database objects improves performance right away?

0 Answers  

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

What is cursor in ms sql server?

0 Answers  

What are the advantages of log shipping?

0 Answers  

What is merge statement?

0 Answers  




SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,

What command do we use to rename a db, a table and a column?

0 Answers  

What is a job?

3 Answers  

What is bit data type?

0 Answers  

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

How to define output parameters in stored procedures?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories