Answer / 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.

Answer / manoj pandey

DELETE vs TRUNCATE
Check: http://sqlwithmanoj.wordpress.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/

~Manoj

Answer / wasimali

1) Delete command maintained the log files in each deleted row but truncate command do not maintained the log files for each deleted row but maintain the record for DE-allocation
of data-pages in the log files

2)Delete is a DML command and truncate is a DDL command.
3)Trigger is fired in case of delete command only but they are not fired when truncate command is used.

4)you can used where clause in case of delete command use to delete a particular row,
but you can not use where clause in case of truncate command use to delete a data from rows.

5) Truncate command reset the identity property to its initial values whereas delete command can not reset its identity property of its column.

What is a result set object returned by mssql_query()?

0 Answers  

---

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

---

what's sql server? : Sql server database administration

0 Answers  

---

What does it mean to be in union?

0 Answers  

---

What is the difference between deallocate cursor and close cursor?

0 Answers  

---

What is the Difference beween sql server 2005 and sql server 2008

3 Answers   CMC, Hitech,

---

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

What is change tracking in sql server?

0 Answers  

---

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

---

Explain system functions or built-in functions? What are different types of system functions?

0 Answers  

---