Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25585 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
How many categories of data types used by sql server?
What is it unwise to create wide clustered index keys?
What will happen if a column containing char type data is changed to the nchar data type?
Can we use where and having clause together?
What is indexed view?
What is raid? : SQL Server Architecture
Does server sql treat char as a variable-length or fixed-length column?
Can you pass expressions to stored procedure parameters?
how to take backup bcp out for a column in table in sql server?
Explain transaction server implicit?
What are the character string functions supported by sql server 2005?
Why variables called the most powerful component of ssis?
What is difference between clustered and non clustered index?
Can we perform backup restore operation on tempdb?
What is a partitioned view?
