The DELETE statement removes rows one at a time and records an entry in
the transaction log for each deleted row.
TRUNCATE TABLE removes the data by deallocating the data pages used to
store the table data and records only the page deallocations in the
transaction log.

Have a nice weekend,

Robin.

-----Oorspronkelijk bericht-----
Van: Edwards Ed
[mailto:mssqldba-ezmlmshield-x8392627.[Email address protected]
Verzonden: vrijdag 29 februari 2008 13:24
Aan: LazyDBA Discussion
Onderwerp: SQL Server Truncate Table

Well, well, well!
It's Fridayyyyyy! Partyyyyyyyy! Hehe. Not so fast! It's test time!
Hehe. Can you win "the COKE"? hehe.


Question: Truncate Table Cannot Be Rolled Back. True or False. As
usual, please provide proof! Hehe.


Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Dr. Eric J. Smith is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page