Answer Posted / skybeaver

/* selecting duplicate rows in a table */
select col1, col2, ..., colN, count(*)
from TableName
group by col1, col2, ..., colN
having count(*) > 1

/* deleting duplicate rows from a table */
select col1, col2, ..., colN, count(*) as "Duplicates"
into #duplicates
from TableName
group by col1, col2, ..., colN
having count(*) > 1

delete TableName
from TableName t, #duplicates d
where t.col1 = d.col1 and
....
t.colN = d.colN

/* damn I'm good! */

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1059

---

explain different types of backups avaialabe in sql server? : Sql server database administration

1034

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2138

---

explain different types of joins? : Sql server database administration

1031

---

Can we use custom code in ssrs?

1165

---

How do I create a partition table in sql server?

1182

---

What is de-normalization in sql database administration? Give examples?

1027

---

What is partition, how will you implement it? : sql server analysis services, ssas

1099

---

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

127

---

Does an index slow down updates on indexed columns?

1033

---

wat wil hapn if we give the both read and deny read permission to user?

2151

---

1 01 101 01010

2100

---

How to update muliple row in single query?

1112

---

How to use “drop” keyword in sql server and give an example?

1193

---

Can you type more than one query in the query editor screen at the same time?

1067

---