Post reply

Temporary Tables and Statistics in Stored Procedures

  • April 12, 2014 at 4:05 am

    #1705515

    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:-)

    Good analysis.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • April 12, 2014 at 12:37 pm

    #1705562

    SQLRNNR (4/11/2014)

    thanks for the question

    +1

    Tom

  • April 14, 2014 at 10:27 am

    #1705831

    Great question, thanks.

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

  • April 15, 2014 at 11:35 am

    #1706207

    Great question. I had to do some research on this one. Learned a lot. Thanks!

  • May 7, 2014 at 11:11 pm

    #1711746

    KWymore (4/15/2014)

    Great question. I had to do some research on this one. Learned a lot. Thanks!

    +1

    Thanks

Viewing 5 posts - 16 through 20 (of 20 total)

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