• Very interesting question 🙂

    In my case on SQL 2008 R2 i receive follow result:

    - table variable - 29290 ms

    - temp table - 240 ms