What are the steps you will take to improve performance of a
poor performing query?
Answer / m.sivakumar
Some general issues that you could talk about would be:
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.
Is This Answer Correct ? | 8 Yes | 1 No |
What is the difference between primary key and unique constraints?
Is it possible to update the views? If yes, how, if not, why?
Do you know what is xpath?
What are the different authentication modes in sql server? How can it be changed?
How check triggers in sql server?
What do you mean by data manipulation language?
How to create a view with data from multiple tables?
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What is 2nf normalization form?
Explain the steps needed to create a scheduled job?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?