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
- 10179 Views
- HCL, I also Faced
- E-Mail Answers
Answer / swapna
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.
Some of the tools/ways that help you troubleshooting
performance problems are: SET SHOWPLAN_ALL ON, SET
SHOWPLAN_TEXT ON, SET STATISTICS IO ON, SQL Server
Profiler, Windows NT /2000 Performance monitor, Graphical
execution plan in Query Analyzer.
| Is This Answer Correct ? | 13 Yes | 1 No |
What is Primary key and foreign key? Give an example
Explain transaction server auto commit?
What is Sqlpaging in SqlServer 2005 ?
Where the sql logs gets stored? : sql server database administration
What is the maximum number of index per table?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is an example of a foreign key?
write an SQL query to list the employees who joined in the month of January?
When columns are added to existing tables, what do they initially contain?
What is function of CUBE ?
What is the purpose of data source?
What is the difference between for auto and for nested?
-
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)
