Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22120 Views
- I also Faced
- E-Mail Answers
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
Give the query of getting last two records from the table in SQL SERVER?
What is oltp (online transaction processing)?
What is master database? : SQL Server Architecture
What is set nocount on?
Characterize join and name diverse sorts of joins?
What are the new data types are introduced in sql 2000?
Which table keeps the locking information?
What does this statement do @@rowcount?
What is the beast way to write CTE in SQL Server ?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is an index in a database?
last function used in MS Access to convert sql what function will use in sql
How to disable a login name in ms sql server?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is sql server database?
