Answer Posted / vijay

WITH INTER_TABLE(ROW, COL1) AS(
select row_number() over (partition by
COL1 order by COL1) as ROW ,COL1 from [TABLE_NAME]
)
Delete from INTER_TABLE where ROW > 1

Explain what are page splits? : SQL Server Architecture

1070

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2488

---

How do I find the transaction log size in sql server?

964

---

Difference between primary key and clustered index?

1012

---

How to delete duplicate rows?

1000

---

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

994

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

1230

---

How to scale out a federation by Sql statement?

116

---

Can you roll back the ddl statement in a trigger?

978

---

What is used to replicate sessions between instances in coldfusion clusters?

1074

---

Explain the first normal form(1nf)?

1030

---

What is change tracking in sql server?

1030

---

Write a SQL query in order to merge two different columns into single column?

1036

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1008

---

What are the types of database recovery models?

1127

---