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 explain what is “asynchronous” communication in sql server service broker?
What is transaction server auto commit?
What are four major operators that can be used to combine conditions on a where clause?
What are different types of data sources?
What is the recursive stored procedure in sql server?
What are the different kinds of ssrs reports?
What are click through reports?
What is the purpose of indexing?
Why should we go for stored procedures? Why not direct queries?
explain extended properties
What are recommended options to be used while using db mirroring? : sql server database administration
What are the difference between primary key and unique key? : sql server database administration
What the different topologies in which replication can be configured?
Explain the commands in sql server?
What is Transparent Data Encryption?