Answer Posted / rajesh bhawsar

delete command, delete row by row and same time it makes an
entry in transaction log
while truncate remove the referance of respective
page/extent and doesn't make any entry in transaction log
truncate is faster then delete.
in case of truncate seed value (auto increment column) reset
to default unlike delete.

Tell me what is de-normalization and what are some of the examples of it?

958

---

What is report subscription?

117

---

How can you tell if a database object is invalid?

1012

---

Which language rdl files made of?

123

---

Explain the purpose of indexes?

893

---

How to return the date part only from a sql server datetime datatype?

1021

---

Write a SQL query to delete a table?

1077

---

What is ems sql management studio? : sql server management studio

1035

---

Explain what is the main purpose of having conversation group?

877

---

Does a sql server 2005 select statement require a from?

969

---

Explain transaction server consistency?

916

---

What are the three different part of rdl file explain them?

253

---

What command is used to create a database in the sql server and how?

1111

---

What is the difference between functions and scalar functions?

1122

---

How to delete multiple rows with one delete statement in ms sql server?

942

---