Answer Posted / satishkulala

select empname from emp group by empname having count(empname)>1

What is the report builder?

139

---

Explain what is the function of sql server agent windows service?

996

---

Which are the new data types introduced in sql server 2008?

882

---

Can a function call a stored procedure in sql server?

966

---

What is bit data type? What's the information that can be stored inside a bit column?

924

---

Does union all remove duplicates?

1069

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1051

---

What are the options which must be set to allow the usage of optimistic models?

963

---

Explain about Normalization?

1069

---

Explain different backup plans?

951

---

What is report subscription?

126

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1024

---

How can windows applications connect to sql servers via odbc?

1128

---

How to change the ownership of a schema in ms sql server?

1198

---

What is a hint?

997

---