Scalability, Availability, Integration with internet, etc.)?

0 Answers  

---

How do you drop an index?

0 Answers  

---

What factors you will consider calculating the storage requirement for that view?

0 Answers  

---

What is 'Join' and explain its various types.

0 Answers   Genpact,

---

What is the query optimization statistics?

1 Answers  

---

---

What is role playing dimension with two examples? : sql server analysis services, ssas

0 Answers  

---

How will you find out if there are expensive SQL statements running or not?

0 Answers   Atos Origin,

---

Working with TLogs

0 Answers  

---

How to create a dynamic cursor with the dynamic option?

0 Answers  

---

How to Update from select query in sql server?

0 Answers  

---

How do I create a partition table in sql server?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---