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.

List the different normalization forms?

0 Answers  

---

What is primary key index?

0 Answers  

---

how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,

---

Determine when an index is appropriate?

0 Answers  

---

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

---

Is Sql non procedural query language?

1 Answers   Verifone,

---

What’s the use of custom fields in report?

0 Answers  

---

Explain about system stored procedure?

0 Answers  

---

what are cursors? : Sql server database administration

0 Answers  

---

How can you check the version of sql server?

0 Answers  

---

What do you mean by acid?

0 Answers  

---

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

---