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 various Operating system files that every SQL server 2005 database has and what is the purpose.
What are trace flags and mention a few common trace flags used with sql server?
How to call stored procedure using http soap?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
How do you drop an index?
What is Cross Join and in which scenario do we use Cross Join?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
How does the report manager work in SSRS?
What is the data tier application?
How to execute a sql statement using mssql_query()?
What is ssl in sql server?
How to use "begin ... End" statement structures in ms sql server?
How would you go about developing a ssrs report?
Can you explain important index characteristics?
