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 are the elements of dbms?
How much is a sql server license?
What is transact-sql language?
How to rename databases in ms sql server?
How to set database to be read_only in ms sql server?
How many columns can exist together per table?
How to delete an existing row with delete statements in ms sql server?
what method you can use to reduce the overhead of Reporting Services data sources?
What is an execution plan? When would you use it?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
What is dimension table? : sql server analysis services, ssas
What is onf in normalization form?
what is the difference between a primary key and a unique key? : Sql server database administration
How to drop an existing table with "drop table" statements in ms sql server?
