Answer Posted / manoj

Check following blog post on how to first identify & then delete duplicate records: http://sqlwithmanoj.wordpress.com/2011/10/14/identify-delete-duplicate-records-from-a-table/


This lists multiple ways to delete duplicates.

Explain full-text query in sql server?

950

---

What is transact-sql language?

1004

---

When you use @@error and try-catch?

979

---

write an SQL query to list the employees who joined in the month of January?

1624

---

What happens if date-only values are provided as date and time literals?

975

---

How to connect to SQL Azure Database by using sqlcmd?

136

---

What are the new features of sql server 2008 r2 reporting service?

193

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

855

---

What is the difference between writing data to mirrored drives versus raid5 drives

871

---

What is database mirroring?

1037

---

Can I disable or restrict ssrs export formats (rendering formats)?

140

---

What are the advantages to use stored procedures?

1028

---

Is sql server difficult to learn?

862

---

What are the types of dml?

930

---

Explain the rules for designing files and file groups in sql server?

928

---