Temporary Tables and Statistics in Stored Procedures

  • lrasner

    SSC Veteran

    Points: 209

    Comments posted to this topic are about the item Temporary Tables and Statistics in Stored Procedures

  • Ford Fairlane

    SSCertifiable

    Points: 7664

    Interesting QotD - Learned something here.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • Stuart Davies

    SSCoach

    Points: 18877

    Ford Fairlane (4/10/2014)


    Interesting QotD - Learned something here.

    +1

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a questionThere are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan I would never join a club that would allow me as a member - Groucho Marx

  • Carlo Romagnano

    SSC-Insane

    Points: 21943

    Ford Fairlane (4/10/2014)


    Interesting QotD - Learned something here.

    Good!

  • free_mascot

    One Orange Chip

    Points: 27168

    Very interesting question!!

    Thanks!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • twin.devil

    SSC-Insane

    Points: 22208

    Thanks lrasner, your question have just awakened me 😀

    Excellent QotD, Thanks for sharing

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    twin.devil (4/11/2014)


    Thanks lrasner, your question have just awakened me 😀

    Excellent QotD, Thanks for sharing

    +1

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

  • Tony Bater

    SSCrazy

    Points: 2150

    I am happy to say I got this right, but not so sure about the reason!

    I didn't know the answer (so learned something here, and that's good), but worked it out from logic alone.

    If #1 was true, then none of the others could be, and as the question states that there are two true statements, then #1 must be false.

    If #2 was true, then so must #3 and #4, hence 3 true statements not 2. So #2 must be false.

    Leaving #3 and #4 as the two true statements.

    A good mental exercise, but not SQL:-)


    Tony

  • SQLDoubleG

    Hall of Fame

    Points: 3090

    Tony Bater (4/11/2014)


    I am happy to say I got this right, but not so sure about the reason!

    I didn't know the answer (so learned something here, and that's good), but worked it out from logic alone.

    If #1 was true, then none of the others could be, and as the question states that there are two true statements, then #1 must be false.

    If #2 was true, then so must #3 and #4, hence 3 true statements not 2. So #2 must be false.

    Leaving #3 and #4 as the two true statements.

    A good mental exercise, but not SQL:-)

    +1

    Nice question!

  • pmadhavapeddi22

    SSCertifiable

    Points: 5306

    Interesting QOD. Learned today

  • Mike Hays

    SSCommitted

    Points: 1871

    Good Question, learned something new....

  • PChiragS

    SSCarpal Tunnel

    Points: 4965

    nice question.

    thanks Lara for sharing.

  • sestell1

    SSChampion

    Points: 10230

    Nice question, thanks! Definitely something I'll be doing some more reading on.

  • SQLRNNR

    SSC Guru

    Points: 281243

    thanks for the question

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • kapfundestanley

    SSCertifiable

    Points: 5630

    Got it wrong ,but learned.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

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

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