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
What is the concept of optimization?
Explain SSRS Architecture?
What is a transactions?
What sql server means?
Mention the different authentication modes in sql server.
What is amo? : sql server analysis services, ssas
Is sql server implemented as a service or an application? : Sql server database administration
What is user defined stored procedures?
What is sql server replication? : sql server replication
Do you know what are the properties of the relational tables?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is sqlservr.exe - process - sql server (sqlex?press)?
You want to implement the one-to-many relationship while designing tables. How would you do it?
What is the default order of an order by clause?
What are difference between Cluster index and Non-Cluster index?