:: 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                      
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)
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  
# 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

Some of the tools/ways that help you troubleshooting
performance problems are: SET SHOWPLAN_ALL ON, SET
Profiler, Windows NT /2000 Performance monitor, Graphical
execution plan in Query Analyzer.

Is This Answer Correct ?    13 Yes 1 No

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  All Rights Reserved.   ::