Answer Posted / aashish lad

-- Here Temp1 is Temporary Table So it will take All records
-- From Mytable With RowNumbar column
-- We can Delete the Record from


SELECT ROW_NUMBER() OVER(PARTITION BY empid ORDER BY empid)
AS RowNumber, * into #temp1 FROM mytable

DELETE FROM #temp1 WHERE RowNumber> 1

INSERT INTO mytable

SELECT * FROM #temp

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2524

---

Is it possible to have clustered index on separate drive from original table location?

968

---

What do you understand by physical_only option in dbcc checkdb?

981

---

Explain how to maintain a fill factor in existing indexes?

996

---

What does the on delete cascade option do?

1018

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1028

---

How many triggers you can have on a table?

998

---

What is scalar user-defined function?

1109

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1019

---

what is datawarehouse?

1121

---

How is foreign key related to primary key?

972

---

Name some of the open source software that you can use in alternative to SSR?

161

---

How to use copy and concatenate commands in SQL?

1144

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

991

---

What is a mutating table error and how can you get around it?

1052

---