How can delete duplicate records in cte in sql server?

0 Answers  

---

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

How to Handle the exceptions in Sqlsrver 2005??

3 Answers   Value Labs, Wipro,

---

How to provide default values to function parameters?

0 Answers  

---

How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,

---

---

Can you use order by when defining a view?

0 Answers  

---

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

---

what is normalization? what is denormalization?

9 Answers   Satyam,

---

what are constraints? : Sql server database administration

0 Answers  

---

Explain activity monitors

0 Answers  

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

---