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
- 4626 Views
- I also Faced
- E-Mail Answers
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 |
Explain “@@rowcount” and “@@error” in sql server?
Who is the owner of a schema in ms sql server?
What is Cross Join
How to replace the Query Result 'Null Value' with a text ?
Can you move the resources after pausing the node? : sql server database administration
In which tcp/ip port does sql server run? Can it be changed?
Why normalization is used?
How to perform backup for certificates in sql server? : sql server security
What is transaction server explicit transaction?
Can a database be shrunk to 0 bytes, if not, why?
How to find the version of sql server? : sql server database administration
How are the unique and primary key constraints different?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
