SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

---

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

---

What are the default system databases in sql server 2000?

0 Answers  

---

What is repeatable read?

0 Answers  

---

Explain transaction isolation levels in sql server?

0 Answers  

---

---

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

---

how many instance use in sql server 2005

4 Answers   EFI, HCL,

---

How can we get count of the number of records in a table?

0 Answers  

---

syntex of insert

7 Answers  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

What are the built in functions in sql server?

0 Answers  

---

What is an extended Stored Procedure?

1 Answers  

---