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 are functions in the sql server?

0 Answers  

---

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,

---

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

---

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

---

What stored by the master? : sql server database administration

0 Answers  

---

What are the purpose of Normalisation?

0 Answers   HCL,

---

What is updatable resultset?

0 Answers  

---

What is difference between primary key and foreign key?

0 Answers  

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

0 Answers  

---

What are trace flags and mention a few common trace flags used with sql server?

0 Answers  

---

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

---