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
- 4497 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
Explain the usage of floor function in sql server.
What is indexing explain it with an example?
How can I create a report based on a query? : sql server management studio
What is subquery? Explain the properties of a subquery?
What are the requirements for sql server 2016?
How to create a scrollable cursor with the scroll option?
What is onf in normalization form?
Describe in brief sql server monitoring ways.
How can you insert values in multiple rows using one Insert statement?
Explain what role entity and relationship play in an ER diagram.
What happens if null values are involved in boolean operations?
How do you make a trace?
Do you know what is a with(nolock)?
explain different levels of normalization? : Sql server database administration
What is the difference between getdate and sysdatetime?
