Well, well, well!
It's Daniel Kast! Hehe. How have you been? Oh my! Phew! "One
COKE" for you! hehe.

It's Fridayyyyyyyyyy! Partyyyyyyyyyy! Hehe.


-----Original Message-----
From: Daniel Kast
[mailto:mssqldba-ezmlmshield-x96605342.[Email address protected]
Sent: Friday, February 29, 2008 8:27 AM
To: LazyDBA Discussion
Subject: Re: SQL Server Truncate Table

Sure one can rollback a truncate.

It's faster than a delete because the whole pages go to the tlog and the

whole table is locked. But the pages are in the tlog so they can be
rolled
back.
...provided that the statement is in an explicit not yet commited
transaction ;-)

Daniel




"Edwards Ed " <mssqldba-ezmlmshield-x8392627.[Email address protected]
29.02.2008 13:24

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
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



**********************************************************************
This e-mail may contain confidential material. It is intended only for
the person or entity which it is addressed to. Any review,
retransmission, dissemination or other use of this information by
persons or entities other than the intended recipient is prohibited. If
you received this e-mail in error, please immediately notify the sender
or The Swiss Raiffeisen Group and delete the material from any and all
computers it may be stored on. Any views or opinions expressed in this
e-mail are those of the sender and do not necessarily coincide with
those of The Swiss Raiffeisen Group. Therefore this e-mail does not
represent a binding agreement nor an offer to deal. E-mail transmission
cannot be guaranteed to be secure or error-free. Information could be
intercepted, corrupted, lost, destroyed, incomplete or may contain
viruses. Neither The Swiss Raiffeisen Group nor the sender can accept
any liability for any kind of damage as the result of viruses or
transmission errors.
**********************************************************************



---------------------------------------------------------------------
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