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 |
How optimize sql query with multiple joins in sql server?
What is a view in sql?
How data can be copied from one table to another table?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the command used to check locks in microsoft sql server?
In clustered and non clustered indexes which one is faster while executing a query ?
Define the term DML, DDL and DTL?
explain different types of backups avaialabe in sql server? : Sql server database administration
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What are the different types of collation sensitivity in sql server?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
How many cores do I need for sql server 2016?