• 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

    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