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 |
Can we insert data into a view?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
Tell me the phases a transaction has to undergo?
How to insert data with null values?
whats the maximum size of view state??
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is the difference between HAVING clause and the WHERE clause?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is a fill factor?
In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
How will u test the stroded procedures and functions? difference between SP and Triggers