What are the advantages of using cte?

0 Answers  

---

What is triggers and stored procedures?

0 Answers  

---

What is meant by indexing?

0 Answers  

---

What is stored procedures?

0 Answers  

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

---

What is indexed views? plz explain with example?

2 Answers  

---

How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,

---

How send email from database?.

3 Answers   CarrizalSoft Technologies, Merrill Lynch,

---

What is a data source or ds? : sql server analysis services, ssas

0 Answers  

---

Define msdb database?

0 Answers  

---

Why and when do stored procedure recompile?

0 Answers  

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---