TRUNCATE vs DELETE

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Noel McKinney » TRUNCATE vs DELETE

TRUNCATE vs DELETE

Rate Topic

Display Mode

Topic Options

Author

Message

Noel McKinney

Posted Thursday, October 08, 2009 9:40 PM

SSCrazy

Group: General Forum Members
Last Login: Thursday, April 05, 2012 2:35 PM
Points: 2,007, Visits: 767

Comments posted to this topic are about the item TRUNCATE vs DELETE

Post #800484

Damian Widera-396333

Posted Friday, October 09, 2009 12:48 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 5:27 AM
Points: 389, Visits: 190

To easy
No chance to make a mistake, even without morning coffee

Kindest Regards,

Damian Widera
SQL Server MVP,
MCT, MCITP-DBA, MCSD.NET

Post #800531

WayneS

Posted Friday, October 09, 2009 2:15 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:59 PM
Points: 6,386, Visits: 8,288

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

Malay Pandey

Posted Friday, October 09, 2009 4:21 AM

Grasshopper

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

cy-dba

Posted Friday, October 09, 2009 7:15 AM

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. Smile

Post #800714

Jesse McLain

Posted Friday, October 09, 2009 7:22 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 06, 2013 8:47 AM
Points: 304, Visits: 552

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

BudaCli

Posted Tuesday, October 13, 2009 5:17 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:16 AM
Points: 1,046, Visits: 575

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

Lempster

Posted Wednesday, October 21, 2009 10:33 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Today @ 5:25 AM
Points: 1,464, Visits: 768

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

Neeraj Prasad Sharma

Posted Thursday, June 06, 2013 3:06 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 242, Visits: 238

i am completely agree with cy-dba

thanx for the question 1+

Neeraj Prasad Sharma
Sql Server Tutorials

Post #1460591

« Prev Topic | Next Topic »

Permissions