ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
What are the steps you will take to improve performance of 
a poor performing query?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are the steps you will take to improve performance of a poor performing query?
Answer
# 1		 
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 ?    6 Yes 0 No
Swapna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
can you any body tell me the how to decrease the logfile  4
sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??  1
What is the difference between a stored procedure and a user defined function in sql server? Millennium2
hi i gone though satyam interview. what is Acid Properties? Satyam2
What is a Linked Server?  1
What is the difference between 2-Tier architecture and 3-Tier architecture Oracle10
How can you see what type of locks used?  1
How reterive duplicate value in SQL?  5
What is database replicaion? What are the different types of replication you can set up in SQL Server?  2
What is a transaction and what are ACID properties? IBM4
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL? HCL3
Can you explain the types of Joins that we can have with Sql Server?  2
There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"  1
What is a deadlock and what is a live lock? How will you go about resolving deadlocks? Microsoft1
What is normalization and its forms? Challenger-Financial3
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?  2
What is a cursor in SQL Server 2000 and their types?  4
How to Run a Query on a Remote SQL Server?  2
What is database replicaion? What are the different types of replication you can set up in SQL Server? HCL4
What is the difference between truncate and delete statement? CTS4
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com