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
Tell me what is the difference between locking and multi-versioning?
What is instead of dml trigger?
What are drillthrough reports?
How does using a separate hard drive for several database objects improves performance right away?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
How many types of keys are there?
Explain why variables called the most powerful component of ssis?
can a table be moved to different filegroup? : Sql server administration
Can you please explain the difference between primary keys and foreign keys?
What is trace flag in sql server?
What is the difference between osql and query analyzer?
What is the process of normalising?
What is page-level compression?
What is function of CUBE ?
What happens if an integer is too big for int date type?
