Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps you will take to improve performance of
a poor performing query?
- 1 Answers
- 10246 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What are the types of ssrs?
What is normalization? Explain different forms of normalization?
How to use order by with union operators in ms sql server?
What is query cost in sql server?
What area unit the various kinds of info compression introduced in sql server 2008?
Can I use sql azure as a backup with log shipping or database mirroring?
What are partitioned views?
What do you understand by check constraint in sql server?
What is the cartesian product of table?
what is the difference between delete table and truncate table commands? : Sql server database administration
What will be the maximum number of indexes per table?
What is dml command?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
How to use subqueries with the exists operators in ms sql server?
What is normalization? Explain its different types?
