ALLInterview.com :: Home Page            
 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                      
Google
   
 
Categories >> Software >> Databases >> SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions (2036)
 SQL Server interview questions  SQL Server Interview Questions (1076)
 MS Access interview questions  MS Access Interview Questions (24)
 MySQL interview questions  MySQL Interview Questions (194)
 Postgre interview questions  Postgre Interview Questions (6)
 Sybase interview questions  Sybase Interview Questions (22)
 DB Architecture interview questions  DB Architecture Interview Questions (5)
 DB Administration interview questions  DB Administration Interview Questions (213)
 DB Development interview questions  DB Development Interview Questions (53)
 SQL PLSQL interview questions  SQL PLSQL Interview Questions (771)
 Databases AllOther interview questions  Databases AllOther Interview Questions (106)
Question
What are the steps you will take to improve performance of 
a poor performing query?
 Question Submitted By :: SQL-Server
I also faced this Question!!     Answer Posted By  
 
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 ?    13 Yes 1 No
Swapna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What are the different types of backup avaible in SQL SErver Emphasis 6
how we can use a database with php. HCL 2
Diffrence between DTS vs SSIS IBM 2
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?   2
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?   1
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode? HCL 3
Can we execute a stored procedure inside a trigger? United-Healthcare 6
How maney row would be print after join if A table have 100 rows and B table have 50 rows... Hewitt 9
what is curser.   9
I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.   7
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?   2
Which institute is best for SQL Server 2005 Training?   6
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com