Answer Posted / kumar.t

Name : New

Sno Name
1 Rajesh
2 Rajesh
3 Raja
4 Raja
5 Arun
6 Bala

Delete From New Where Sno Not IN
(Select Min(Sno) From New Group By Name)

Tell me what do we need queues in sql service broker?

1005

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1060

---

What are the different SQL Server Versions you have worked on?

1014

---

Explain view in sql server?

1061

---

Can we use where and having clause together?

1055

---

What is the purpose of floor function?

1046

---

What is blocking?

1074

---

Explain activity monitors

1085

---

Is natural join and equi join same?

982

---

What is query processing?

946

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

1082

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1127

---

Explain filestream storage of sql server 2008?

1025

---

Explain table valued parameters in sql server? Why tvp used?

1029

---

Explain how does the report manager work in ssrs?

964

---