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 coalesce and check constraint in sql server?

0 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

---

Explain use of expression builder.

0 Answers  

---

Explain different types of collation sensitivity?

0 Answers  

---

what is an extended stored procedure? : Sql server database administration

0 Answers  

---

Where do we use trace frag?

0 Answers  

---

What are the recovery models in sql server 2000?

0 Answers  

---

How self join is different from outer join?

0 Answers   Blue Star,

---

What is 2nf normalization form?

0 Answers  

---

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  

---

How do I view a stored procedure in sql server?

0 Answers  

---