Post reply

Temporary Tables and Statistics in Stored Procedures

  • April 10, 2014 at 9:38 pm

    #287525

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

  • April 10, 2014 at 9:40 pm

    #1705103

    Interesting QotD - Learned something here.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • April 11, 2014 at 12:41 am

    #1705114

    Ford Fairlane (4/10/2014)

    Interesting QotD - Learned something here.

    +1

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There 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

  • April 11, 2014 at 12:58 am

    #1705115

    Ford Fairlane (4/10/2014)

    Interesting QotD - Learned something here.

    Good!

  • April 11, 2014 at 1:03 am

    #1705116

    Very interesting question!!

    Thanks!

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

  • April 11, 2014 at 1:20 am

    #1705119

    Thanks lrasner, your question have just awakened me 😀

    Excellent QotD, Thanks for sharing

  • April 11, 2014 at 1:53 am

    #1705137

    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.

  • April 11, 2014 at 2:09 am

    #1705142

    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

  • April 11, 2014 at 3:29 am

    #1705162

    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!

  • April 11, 2014 at 6:00 am

    #1705216

    Interesting QOD. Learned today

  • April 11, 2014 at 7:40 am

    #1705287

    Good Question, learned something new....

  • April 11, 2014 at 7:57 am

    #1705302

    nice question.

    thanks Lara for sharing.

  • April 11, 2014 at 8:22 am

    #1705325

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

  • April 11, 2014 at 10:04 am

    #1705398

    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

  • April 12, 2014 at 2:54 am

    #1705512

    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 20 total)

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