Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajesh bhawsar
delete command, delete row by row and same time it makes an
entry in transaction log
while truncate remove the referance of respective
page/extent and doesn't make any entry in transaction log
truncate is faster then delete.
in case of truncate seed value (auto increment column) reset
to default unlike delete.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What happens if you add a new index to large table?
What is user-defined multi-statement table-valued function?
How to add more data to the testing table in ms sql server?
Can you please explain the difference between primary keys and foreign keys?
List some case manipulation functions in sql?
How to replace the Query Result 'Null Value' with a text ?
What is function of CUBE ?
How to resolve the orphan use problem? : sql server security
What is difference between view and materialized view?
How to delete database objects with "drop" statements in ms sql server?
How can sql server instances be hidden? : sql server security
List the different types of collation sensitivities in sql server?
what is nonclustered index
What are the different ways you can create databases in sql server?
Explain the etl (extraction, transformation, and loading)?
