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 is the difference between count and distinct count?

0 Answers  

How to set the current database in ms sql server?

0 Answers  

What are binary string data types in ms sql server?

0 Answers  

How to create a local temporary stored procedure?

0 Answers  

How to update existing rows in a table?

1 Answers  

Can a unique index be created on a column, which contains null?

0 Answers  

Issues related in upgrading SQL Server 2000 to 2005 / 2008

0 Answers  

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers   TCS, Wipro,

Why use “in” clause in sql server?

0 Answers  

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,

Do you know what is replace and stuff function in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories