Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25183 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
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?
