• Nils Gustav Stråbø (8/17/2011)


    Thanks for the question 🙂

    Yes, it's a good question.

    It will be interesting to see how many still think that truncate is a non-logged operation.

    Interesting and somewhat horrifying - up to now, 43% said delete was not logged, which is amazing considering how much discussion of that there has been on SQLServerCentral.com; and more tha 50% got it wrong that way or some other way. 6% chosing "delete resets ID, truncate does not" is crazy, I hope these guys never use identity columns because if they believe that nonsense they are going to make some really horrible mistakes, like thinking that if their table behaves like a stack IDs will always be contiguous, which can cause lots of lovely bugs.

    Tom