Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22992 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / archana motagi
Both the operations can be rolled back.The difference is,
DELETE TABLE is a logged operation, so the deletion of each
row gets
logged in the transaction log, which makes it slow.
TRUNCATE TABLE
also deletes all the rows in a table, but it won't log the
deletion of
each row, instead it logs the deallocation of the data
pages of the
table, which makes it faster.
| Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
What stored by the msdb? : sql server database administration
What is user-defined inline table-valued function?
Can truncate be rolled back?
How to use old values to define new values in update statements in ms sql server?
Explain transaction server explicit transaction?
tell me the disaster recovery plan
Can we use trigger new in before insert?
How many columns can we include on clustered index ?
Mention what are the core components of ssrs?
Scalability, Availability, Integration with internet, etc.)?
What are extended events in sql server?
How can we call UDF(User Define Function) using C# code in ASP.net ?
Explain syntax for viewing, dropping and disabling triggers?
How to view existing indexes on an given table using sp_help?
What is the order by used for?
