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 8:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

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

If it's a good article? No, not at all. I've done it in the past.
That being said, I do always prefer an official MS reference. But if there isn't one, a third-party reference that is solid enough (read: based on other MS material, or equipped with enough code samples to prove that the statements are true) will do just fine.

I don't know your article, but I do know you - and that's enough for me to assume that your article will meet the bar. Easily!



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1247446
Posted Monday, February 6, 2012 8:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:36 PM
Points: 5,601, Visits: 25,005
GilaMonster (2/6/2012)
Is it bad form, if you create a QotD, to list your own article as a reference?


Might not be bad form, but I can just image the list of those who whine and cry "give me my points".

So then ask some one else to be the author of the QOD or QODs who then can site your article(s) as justification.



If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1247454
Posted Monday, February 6, 2012 9:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 4, 2014 8:10 AM
Points: 1,635, Visits: 1,972
GilaMonster (2/6/2012)
Is it bad form, if you create a QotD, to list your own article as a reference?


It's probably better to find another one just so there's input from two different people but if it's the best reference (that can be found without a quick search) I would say go for it. No sense in wasting time when you have a good, accurate article that you can find quickly.
Post #1247458
Posted Monday, February 6, 2012 9:21 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, August 22, 2014 8:50 AM
Points: 4,425, Visits: 3,417
Great question to start a week with. Thanks, Craig!
Post #1247479
Posted Monday, February 6, 2012 9:29 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:23 AM
Points: 3,299, Visits: 1,978
Nice question. Thanks Craig.
Post #1247491
Posted Monday, February 6, 2012 9:55 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:51 PM
Points: 21,644, Visits: 15,317
GilaMonster (2/6/2012)
Is it bad form, if you create a QotD, to list your own article as a reference?


Nah - go for it.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1247515
Posted Monday, February 6, 2012 10:12 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:20 AM
Points: 1,740, Visits: 6,366
Stewart "Arturius" Campbell (2/6/2012)
Wonder when this was changed?
Granted I haven't worked in Oracle itself since 7b...


It was always the case in Oracle 7 and before as well (ie when I last worked with it, around 1996). Which is why I once thought that truncate couldn't be rolled back in MSSQL either.
Post #1247527
Posted Monday, February 6, 2012 10:23 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: Monday, March 10, 2014 9:39 AM
Points: 579, Visits: 27,690
GilaMonster (2/6/2012)
Is it bad form, if you create a QotD, to list your own article as a reference?


I wouldn't mind :). Still, an msdn reference, if there is any relevant, would be a good addition.
Post #1247534
Posted Monday, February 6, 2012 10:44 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:24 AM
Points: 1,867, Visits: 2,020
vk-kirov (2/6/2012)
Hugo Kornelis (2/6/2012)

And 34% of them are for "you can never rollback a truncate table statement"

Maybe they are Oracle refugees? http://www.sqlservercentral.com/articles/Raw+Materials/71108/


AHHH! I've been discovered! Oh well, I've been at least partially in the SQL Server world since 2000 so I guess I should know better by now.
Post #1247557
Posted Monday, February 6, 2012 10:55 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
thanks for the question
Post #1247568
« Prev Topic | Next Topic »

Add to briefcase «««23456»»»

Permissions Expand / Collapse