Answer Posted / ashish jain

create table emp

empid empname
----- --------
101 a
102 b
103 a
104 c
105 a

select empname from emp where count(empname)>1

What is sql language?

1145

---

Ms sql server index?

1066

---

What samples and sample databases are provided by microsoft?

1037

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

979

---

In case you have filters in your report, when filters will be applied in cached report instance?

113

---

How do clustered indexes store data?

1106

---

What is query optimization process?

1015

---

What are the benefits of normalization?

1109

---

What is measure group, measure? : sql server analysis services, ssas

1013

---

What is the difference between clustered and a non-clustered index?

1028

---

What are the diifferences between the ms sql server vs mysql?

1175

---

What does normalization do to data?

1073

---

What are advantages of ssrs or why we should use ssrs?

139

---

What is "scheduled jobs" or "scheduled tasks"?

979

---

What is the concept of optimization?

1060

---