TRUNCATE vs DELETE

  • Noel McKinney

    Hall of Fame

    Points: 3385

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

  • Damian Widera-396333

    Ten Centuries

    Points: 1186

    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

  • WayneS

    SSC Guru

    Points: 95387

    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
    Author - SQL Server T-SQL Recipes


    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
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • Malay Pandey

    SSC Rookie

    Points: 45

    Too easy.:-)

    I got a prompt solution.

    Malay K. Pandey

  • cy-dba

    SSCarpal Tunnel

    Points: 4149

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

  • Jesse McLain

    SSCommitted

    Points: 1784

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

  • BudaCli

    Hall of Fame

    Points: 3383

    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
  • Lempster

    SSCoach

    Points: 15651

    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

  • Neeraj Prasad Sharma

    Ten Centuries

    Points: 1285

    i am completely agree with cy-dba

    thanx for the question 1+

    Neeraj Prasad Sharma
    Sql Server Tutorials

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply