• TomThomson (5/23/2014)


    SQLRNNR (5/23/2014)


    I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

    Temp tables can be partitioned. With three correct answers and the question requesting a pick 2, it makes it hard to decided which 2 of 3 to pick.

    Here is a rundown of the three options that are correct.

    http://bit.ly/1kb7zz7

    Wow. I'm surprised. I can't imagine what I would use it for, but it seems eminently reasonable for the feature to be available even tough until now I believed it wasn't.

    Yeah it is kinda hard to figure out a possible use-case. But it is kinda cool and fun to play with at least. 😎

    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