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

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

Difference between primary key and clustered index?

0 Answers  

What are the properties of the transaction?

0 Answers  

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  

how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

What is transaction server distributed transaction?

0 Answers  

Explain what is analysis service repository?

0 Answers  

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

Introduction of rollup clause using sum and group by clause?

0 Answers  

How many non clustered indexes there can be on table ?

0 Answers  

What is difference between temp table and cte?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories