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
- 4618 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
Write a SQL query to delete a table?
Equi join and non equi join is possible with sql server?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
How to get a list of all tables with "sys.tables" view in ms sql server?
how to control the amount of free space in your index pages? : Sql server database administration
How to use copy and concatenate commands in SQL?
Can multiple columns be used in sql group by clause in ms sql server?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
How do I connect to sql server database?
Can another user execute your local temporary stored procedures?
Does server sql treat char as a variable-length or fixed-length column?
What is the meaning of resultset type_scroll_insensitive?
Explain the steps needed to create a scheduled job?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What is updatable resultset?
