Answer Posted / navaneethakrishnan

table name : tblduplicate

Ans : DELETE TOP(1) FROM [tblduplicate] WHERE [ID] = 1

Example :

CREATE TABLE tblduplicate(ID int NOT NULL, Name varchar(50))

insert into tblduplicate values(1, 'Name1')
insert into tblduplicate values(1, 'Name1')
insert into tblduplicate values(2, 'Name2')
insert into tblduplicate values(2, 'Name2')
insert into tblduplicate values(3, 'Name3')
insert into tblduplicate values(3, 'Name3')

select * from tblduplicate

Result :
1 Name1
1 Name1
2 Name2
2 Name2
3 Name3
3 Name3

DELETE TOP(1) FROM [tblduplicate] WHERE [ID] = 1

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1138

---

Explain table valued parameters in sql server? Why tvp used?

1024

---

Explain difference between cross join and full outer join?

1009

---

What is sql server query analyzer?

1035

---

how would you improve etl (extract, transform, load) throughput?

1029

---

Do you know the different ddl commands in sql?

1056

---

What is a heap?

1039

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2762

---

Can I save my report as html, excel or word? : sql server management studio

955

---

Tell me what is use of except clause? How it differs from not in clause?

962

---

What are partitioned views?

1002

---

what's the difference between a primary key and a unique key? : Sql server database administration

957

---

Explain how many normalization forms?

1037

---

what is raid? : Sql server database administration

1045

---

What is an indexing technique?

937

---