Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What are acid properties of transaction?

0 Answers  

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

Where are full-text indexes stored?

0 Answers  

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

0 Answers  

What are the steps you should follow to start sql server in single-user mode?

0 Answers  

How to retrieve error messages using odbc_errormsg()?

0 Answers  

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

How to test odbc dsn connection settings?

0 Answers  

Explain the benefits of user-defined functions?

0 Answers  

Which are the important points to note when multilanguage data is stored in a table?

0 Answers  

Please tell me some knowledge about Clustering and how to add clustering?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories