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

TRUNCATE vs DELETE Expand / Collapse
Author
Message
Posted Thursday, October 08, 2009 9:40 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 4:12 PM
Points: 2,007, Visits: 768
Comments posted to this topic are about the item TRUNCATE vs DELETE
Post #800484
Posted Friday, October 09, 2009 12:48 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, March 30, 2014 11:40 AM
Points: 459, Visits: 256
To easy
No chance to make a mistake, even without morning coffee


Kindest Regards,

Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
Post #800531
Posted Friday, October 09, 2009 2:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:57 PM
Points: 6,544, Visits: 8,758
Damian, I also thought it was on the easy side. But, I was also (pleasantly) surprised at the high number of folks that got this right (69% at the time of this posting)... I've seen way too many people get this wrong.

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #800564
Posted Friday, October 09, 2009 4:21 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 31, 2011 11:55 PM
Points: 15, Visits: 5
Too easy.

I got a prompt solution.


Malay K. Pandey
Post #800627
Posted Friday, October 09, 2009 7:15 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: Wednesday, August 17, 2011 7:09 AM
Points: 869, Visits: 963
I thought it was a good question. There's a wide range of members here with varying experience so what may be easy for some may not be for others. If it was "too easy", then everyone would be getting it correct.
Post #800714
Posted Friday, October 09, 2009 7:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:30 PM
Points: 305, Visits: 564
The question was easy in a technical sense, but also had a psychological angle what with the "2", "three" number-word confusion. Sort of like the psych test (the "Stroop effect"), where you have to answer in what color a word is written, where the actual word is also a color, but different than the actual color (e.g., "Blue", written in red ink).

Jesse McLain
jesse@jessemclain.com
www.jessemclain.com
www.jessesql.blogspot.com
Post #800724
Posted Tuesday, October 13, 2009 5:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 05, 2013 6:08 AM
Points: 1,076, Visits: 591
Not that bad but I thought that this was a little bit simple as well.

What you don't know won't hurt you but what you know will make you plan to know better
Post #802067
Posted Wednesday, October 21, 2009 10:33 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:12 AM
Points: 1,887, Visits: 1,179
duda (10/13/2009)
Not that bad but I thought that this was a little bit simple as well.


It's simple...provided you don't skim over the code, miss the 'truncate', see the 'delete' and therefore choose the wrong answer! Kicking myself over that one
Post #806658
Posted Thursday, June 06, 2013 3:06 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 27, 2013 5:37 AM
Points: 306, Visits: 524

i am completely agree with cy-dba

thanx for the question 1+


Neeraj Prasad Sharma
Sql Server Tutorials
Post #1460591
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse