If you put it in a transaction and rollback instead of commit, the
actual truncation never took place (a real truncation cannot be rolled
back, you will need to apply a backup). It's like an insert in a
transaction. After the begin tran and before the rollback or commit,
nothing really changed.
-----Oorspronkelijk bericht-----
Van: Bellizzi Christopher Joseph
[mailto:mssqldba-ezmlmshield-x4232368.[Email address protected]
Verzonden: vrijdag 29 februari 2008 15:32
Aan: LazyDBA Discussion
Onderwerp: RE: SQL Server Truncate Table
No coke's, One adult beverage of your choice. You failed to mention
that I think it needs to be wrapped in a transaction.
PAYCHEX
Christopher Bellizzi
Information Technology * Database Administration
675 Basket Road * Webster, New York 14580
(585) 216-0670 * [Email address protected]
-----Original Message-----
From: Albert Frazer
[mailto:mssqldba-ezmlmshield-x21447655.[Email address protected]
Sent: Friday, February 29, 2008 9:01 AM
To: LazyDBA Discussion
Subject: RE: SQL Server Truncate Table
Ed,
Where's our COKEs? We are waiting. :-)
Albert Frazer
Home Decor Products, Inc
www.hdpi.com
732-593-3637 (office)
732-570-4465 (cell)
-----Original Message-----
From: Ubedur Rehman [mailto:mssqldba-ezmlmshield-x880097.[Email address
protected]
Sent: Friday, February 29, 2008 8:35 AM
To: LazyDBA Discussion
Subject: RE: SQL Server Truncate Table
That's correct ...
-----Original Message-----
From: Cappelleveen PER van
[mailto:mssqldba-ezmlmshield-x52168642.[Email address protected]
Sent: Friday, February 29, 2008 6:50 PM
To: LazyDBA Discussion
Subject: RE: SQL Server Truncate Table
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
---------------------------------------------------------------------
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 message may contain confidential, proprietary or legally
privileged information. It should not be used by anyone who is not the
original intended recipient.If you have erroneously received this
message, please delete it immediately and notify the sender. The
recipient acknowledges that 3i Infotech or its subsidiaries and
associated companies, (collectively "3i Infotech"), are unable to
exercise control or ensure or guarantee the integrity of/over the
contents of the information contained in e-mail transmissions and
further acknowledges that any views expressed in this message are those
of the individual sender and no binding nature of the message shall be
implied or assumed unless the sender does so expressly with due
authority of 3i Infotech. Before opening any attachments please check
them for viruses and defects.
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
-----------------------------------------
The information contained in this message may be privileged,
confidential, and protected from disclosure. If the reader of this
message is not the intended recipient, or any employee or agent
responsible for delivering this message to the intended recipient, you
are hereby notified that any dissemination, distribution, or copying of
this communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.
Thank you. Paychex, Inc.
---------------------------------------------------------------------
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