Answer Posted / hari

Delete - is logged operation,so deletion of each row get
logged into the transcation log.
Truncate - won't logged
Delete - use where condition
Truncate - Can't use where condition
delete - fire the trigger
Trunacte - can't fire the triggger

Describe how to use the linked server?

1079

---

Explain the third normal form(3nf)?

904

---

How can a user-defined datatype be created?

947

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

1008

---

Is it true, that there is no difference between a rule and a check constraint?

984

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

949

---

What’s the use of custom fields in report?

899

---

Can two tables have the same primary key?

1149

---

What is unique key constraint?

1002

---

What is a database table?

937

---

How to copy the tables, schema and views from one sql server to another?

1003

---

What are the drawbacks of reporting in ssrs?

145

---

Describe the left outer join & right outer join. : sql server database administration

963

---

Can you explain powershell included in sql server 2008?

900

---

how to avoid cursors? : Sql server database administration

925

---