Post reply

Union results

  • September 21, 2011 at 8:23 pm

    #245246

    Comments posted to this topic are about the item Union results

  • September 21, 2011 at 10:31 pm

    #1384937

    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

  • September 22, 2011 at 12:33 am

    #1384953

    Thank you for the question,

    Regards,

    Iulian

  • September 22, 2011 at 1:21 am

    #1384963

    Very simple. Thanks. 🙂

  • September 22, 2011 at 1:40 am

    This was removed by the editor as SPAM

  • September 22, 2011 at 2:06 am

    #1384977

    Good question, thanks.

    M&M

  • September 22, 2011 at 5:28 am

    #1385057

    Nice example of the question not being more complicated than necessary to demonstrate the point. Thanks for the question.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • September 22, 2011 at 5:48 am

    #1385068

    Good questions - thanks

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

  • September 22, 2011 at 5:58 am

    #1385073

    thanks for the question!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • September 22, 2011 at 5:59 am

    #1385074

    Good straight forward question. Thanks for posting it.

    http://brittcluff.blogspot.com/

  • September 22, 2011 at 6:42 am

    #1385106

    Ha! My reasoning was right, but apparently I need some more caffeine so I can count. 🙂

  • September 22, 2011 at 7:09 am

    #1385126

    Lost the point but learned something new.

    I knew that union deduped the sets, but I never thought it through to the logical conclusion that it dedups all rows in all sets. Makes sense though.

    Thanks for stretching my brain this morning.

  • September 22, 2011 at 7:25 am

    #1385137

    Tony++ (9/22/2011)

    Lost the point but learned something new.

    I knew that union deduped the sets, but I never thought it through to the logical conclusion that it dedups all rows in all sets. Makes sense though.

    Thanks for stretching my brain this morning.

    Well, technically it doesn't dedupe all rows in all sets. It dedupes all of the rows in the output. It essentially performs a DISTINCT operation on the final intermediate data set.

  • September 22, 2011 at 8:00 am

    #1385169

    Daniel Bowlin (9/22/2011)

    Ha! My reasoning was right, but apparently I need some more caffeine so I can count. 🙂

    Yes, I saw 1,2,3 and almost forgot to count the null value. Good straight forward question with all the likely wrong answers.

  • September 22, 2011 at 8:47 am

    #1385212

    Thanks - Nice easy question to kick of the day.

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

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