Temporary Tables and Statistics in Stored Procedures

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

  • Interesting QotD - Learned something here.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • 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

  • Ford Fairlane (4/10/2014)


    Interesting QotD - Learned something here.

    Good!

  • Very interesting question!!

    Thanks!

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

  • Thanks lrasner, your question have just awakened me 😀

    Excellent QotD, Thanks for sharing

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

  • 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

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

  • Interesting QOD. Learned today

  • Good Question, learned something new....

  • nice question.

    thanks Lara for sharing.

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

  • 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

  • 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