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.

How to list all dsn entries on your local machine using odbc_data_source()?

1 Answers  

---

How to execute function in stored procedure sql server?

1 Answers  

---

What are the requirements on sql server network connections?

1 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

---

what happens on checkpoint? : Sql server database administration

1 Answers  

---

what are the Prerequisites for Replication?

2 Answers   IBM,

---

How to Get the last identity value used

4 Answers  

---

What is optimistic concurrency?

1 Answers  

---

Can you tell me about the concept of ER diagrams?

1 Answers  

---

How do I find the sql server version?

0 Answers  

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1 Answers  

---