Hey Ubedur Rehman,
You said " That's correct ..."! hehe. Oh my! Phew! "One COKE" for
you! hehe.
-----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
MS Sql Server LazyDBA home page