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
- 4576 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to define and use table alias names in ms sql server?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
How to use subqueries with the in operators in ms sql server?
What is the new security features added in sql server 2014? : sql server security
What are the recovery models in sql server 2000?
What is the full form of dql?
How do you trace the traffic hitting a sql server?
What is temporary stored procedure?
Define Wed Edition in SQL Azure?
What are various limitations of the views?
Are semicolons required at the end of sql statements in sql server 2005?
Should you normalize audio?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What extended events?
How can we migrate from SQL server to SQL Azure?
