Answer Posted / srisenthil

delete table gives the transactional log where as in
truncate it is not delete the total rows inthe table but
structure of the table has never changed after the
statement is executed it is roll back and the constraints
after the delete statement is remain same where as it is
not in the truncate statement

What is a Join and explain its types?

1103

---

What is pivot and unpivot?

1013

---

How to disconnect from a sql server using mssql_close()?

1109

---

Explain transaction isolation levels in sql server?

1116

---

What do you mean by sql server agent?

990

---

What is trigger and different types of Triggers?

1143

---

Do you know what is fill factor and pad index?

1004

---

What are the advantages of partitioning?

1127

---

Benefits of Stored Procedures?

972

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1206

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2069

---

How to set database to be single_user in ms sql server?

1029

---

Tell me when is the update_statistics command used?

1112

---

Is the primary key column of a table an index in ms sql server?

962

---

Write a query to find 5th highest amount paid from the customer table.

934

---