Answer Posted / subramanya gv

Union is used to combining the data with out duplication and
effectively it is faster.
Union all is used to combining the data with duplication so
comparatively it is slower.

How do I debug a stored procedure in sql server?

541

---

What authentication modes does sql server support?

599

---

Explain data warehousing in sql server?

604

---

How many types of attribute relationships are there? : sql server analysis services, ssas

588

---

Explain about link server in sql server?

535

---

---

Explain subquery and state its properties?

551

---

what exactly sql injuction.how to overcome.....

2043

---

What is enhanced database mirroring in sql server 2008?

517

---

can you instantiate a com object by using t-sql? : Sql server database administration

523

---

Do you know what is rank function?

627

---

What are diverse clauses that form a part of sql?

601

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

610

---

Explain aggregate functions?

566

---

What is the security principal at the database level that represents your session?

541

---

What are the functions in sql server?

549

---