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

Explain contrast amongst grouped and non-bunched records?

0 Answers  

Explain data warehousing in sql server?

0 Answers  

Can I save my report as html, excel or word? : sql server management studio

0 Answers  

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

List all the types of user-defined functions?

0 Answers  

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

Why are sql functions used?

0 Answers  

What are different types of schemas?

0 Answers  

how to connect sybase to sql server 2005?.

1 Answers   ABC,

For more SQL Server Interview Questions Click Here
Categories