Answer Posted / enis ertem

with DeleteDups as
(
Select * from TableA AS T1
where KeyCol <
(Select Max(Keycol) from TableA as T2
where t1.Id = T2.ID)
)

Delete from Delete Dups;

System requirements for sql server 2005 express edition?

1033

---

How to create a simple user defined function in ms sql server?

1027

---

What happens to a statement batch if there is a compilation error?

969

---

Explain how to maintain a fill factor in existing indexes?

996

---

What do you mean by cardinality?

903

---

What are the advantages of the mirroring?

1094

---

What are trace flags?

1037

---

How to list all triggers in the database with sys.triggers in ms sql server?

1083

---

What is a performance monitor?

976

---

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? : Sql server administration

959

---

How can you check the version of sql server?

1098

---

What are the tool windows in sql server management studio? : sql server management studio

1082

---

What are the advantages dts has over bcp?

1002

---

Explain the dirty pages?

1012

---

Create and insert into temp table in sql server?

1036

---