Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

How to write a query with a full outer join in ms sql server?

0 Answers  

---

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

What is de-normalization and what are some of the examples of it?

0 Answers  

---

How can you ensure that the database and sql server based application perform well?

0 Answers  

---

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What is the use of stored procedure?

0 Answers  

---

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

---

Explain indexed view?

1 Answers  

---

Why is replication required on the sql server?

0 Answers  

---