Post reply

Truncate Table

  • March 27, 2013 at 8:23 pm

    #272617

    Comments posted to this topic are about the item Truncate Table

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • March 27, 2013 at 8:24 pm

    #1601440

    Thanks for a nice clear question

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • March 27, 2013 at 10:43 pm

    #1601448

    Good one Vinay!

    Thanks 🙂

    ~ Lokesh Vij

    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • March 27, 2013 at 11:24 pm

    #1601450

    Good one 🙂

    +1 😛

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • March 28, 2013 at 1:07 am

    #1601470

    good question... Looked something different

    Manik
    You cannot get to the top by sitting on your bottom.

  • March 28, 2013 at 3:41 am

    #1601508

    Whoops, guessed the wrong one. Nice question, learned something.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 28, 2013 at 3:48 am

    #1601515

    I'm happy to admit I didn't know that one - it does make sense logically but I had to check.

  • March 28, 2013 at 4:31 am

    #1601537

    Nice straightforward question.

    Tom

  • March 28, 2013 at 4:41 am

    #1601541

    Good straightforward question.

    -----------------
    Gobikannan

  • March 28, 2013 at 5:31 am

    This was removed by the editor as SPAM

  • March 28, 2013 at 5:34 am

    #1601564

    Awesome, actually really nice one.

    (I had developed imaginary theory on this long back- what if the table is self joined with the key and would truncate work? - and I answered myself "probably yes - as it is a same table" - but never tried it practically, this was really good to see my imagination in the reality)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • March 28, 2013 at 7:07 am

    #1601602

    AAhhhh!!!!!! This one hurts.. I didn't trust my instincts and on top was lazy to check...

    ___________________________________________________________________
    If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:

  • March 28, 2013 at 7:14 am

    #1601605

    Interesting, good question.

  • March 28, 2013 at 7:38 am

    #1601614

    Great question. Took a guess on this one and got it right. Definitely learned something today. Thanks!


    Everything is awesome!

  • March 28, 2013 at 7:58 am

    #1601625

    Koen Verbeeck (3/28/2013)

    Whoops, guessed the wrong one. Nice question, learned something.

    +1 didn't realize this either... probably because in general the tables I want to truncate have additional foreign keys that depend on them 🙂

    Still... good to know.


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

Viewing 15 posts - 1 through 15 (of 33 total)

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