Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456»»

TRUNCATE TABLE and ROLLBACK TRAN Expand / Collapse
Author
Message
Posted Monday, February 6, 2012 11:06 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:37 PM
Points: 568, Visits: 69,904
Nice and simple. Thanks.
Post #1247576
Posted Monday, February 6, 2012 11:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:42 PM
Points: 6,158, Visits: 7,221
My sincere apologies to those of you who have done counter-myth articles of this nature. I meant to say no OFFICIAL documentation on recovery mode associations, but there are blogs out there that discuss Truncate Rollbacks. Apparently I faux pas'd when I gave it to Steve. Apologies to y'alls fine work.

Thanks for all the well-wishes. And yes, the distribution is disturbing.



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1247584
Posted Monday, February 6, 2012 6:48 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:58 AM
Points: 11,192, Visits: 11,097
GilaMonster (2/6/2012)
Is it bad form, if you create a QotD, to list your own article as a reference?

I hope not, since I have done this a couple of times. That said, I found two other (non-official, but well-regarded) references and listed them before my own.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1247779
Posted Tuesday, February 7, 2012 7:33 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 26, 2014 5:34 AM
Points: 897, Visits: 1,486
Thanks to Craig for the question and Paul for the link to Kalen's article.
It's really good to know that SQL Server will exclusively lock the pages that were truncated until the transaction has ended, so no inconsistent reallocations will occur.

Also about Oracle: why would they create a restriction for the TRUNCATE TABLE in later versions when in version 7 the command could be rolled back?

An excellent QoTD.



Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2
Post #1248100
Posted Wednesday, February 8, 2012 6:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:37 AM
Points: 7,051, Visits: 6,814
GilaMonster (2/6/2012)
Given the distribution of answers, I'm considering a followup question - "does recovery model ever affect the ability to rollback transactions?" because it appears way too many people don't understand what recovery models do.


Or maybe create MotD (Myth of the Day)



Far away is close at hand in the images of elsewhere.

Anon.

Post #1248927
Posted Wednesday, February 8, 2012 10:15 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:33 PM
Points: 4,388, Visits: 3,399
David Burrows (2/8/2012)
GilaMonster (2/6/2012)
Given the distribution of answers, I'm considering a followup question - "does recovery model ever affect the ability to rollback transactions?" because it appears way too many people don't understand what recovery models do.


Or maybe create MotD (Myth of the Day)

They seem to pop up on their own, without anyone really trying.
Post #1249178
Posted Thursday, February 9, 2012 2:36 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:02 PM
Points: 8,563, Visits: 9,064
GilaMonster (2/6/2012)
Is it bad form, if you create a QotD, to list your own article as a reference?

depends who does it. It won't be bad form if you do it.


Tom
Post #1249549
Posted Saturday, February 11, 2012 7:15 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Good question. I missed it but learned something.

http://brittcluff.blogspot.com/
Post #1250747
Posted Friday, February 17, 2012 8:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 3, 2013 1:55 AM
Points: 298, Visits: 236
Good question ... thanks!
Post #1253894
Posted Saturday, March 31, 2012 2:27 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, June 28, 2014 8:50 AM
Points: 2,649, Visits: 766
Nice to test and show answer as absolute.

Jamie
Post #1276226
« Prev Topic | Next Topic »

Add to briefcase «««23456»»

Permissions Expand / Collapse