Can you tell me the difference between DELETE & TRUNCATE
commands?

Answer Posted / kmbkrishnan

Delete Command require Log file updation for each row of
deleting process. But the Truncate command not.
So, the Truncate Command is so faster than Delete Command.

Is This Answer Correct ?    28 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the concept of optimization?

804


Explain SSRS Architecture?

164


What is a transactions?

792


What sql server means?

763


Mention the different authentication modes in sql server.

723


What is amo? : sql server analysis services, ssas

863


Is sql server implemented as a service or an application? : Sql server database administration

724


What is user defined stored procedures?

741


What is sql server replication? : sql server replication

710


Do you know what are the properties of the relational tables?

823


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1721


What is sqlservr.exe - process - sql server (sqlex?press)?

819


You want to implement the one-to-many relationship while designing tables. How would you do it?

731


What is the default order of an order by clause?

797


What are difference between Cluster index and Non-Cluster index?

812