How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  

---

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

---

Define left outer join in sql server joins?

0 Answers  

---

What is field with example?

0 Answers  

---

What is the server name in sql server?

0 Answers  

---

---

What are the advantages to use stored procedures?

0 Answers   Ernst Young,

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

0 Answers  

---

What is self contained sub query?

0 Answers  

---

Can we perform backup restore operation on tempdb?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What happens if you delete a table that is used by a view?

0 Answers  

---

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

---