dgvozdetsky (10/3/2011)
Very interesting question 🙂In my case on SQL 2008 R2 i receive follow result:
- table variable - 29290 ms
- temp table - 240 ms
Cool. The comment block in the start of the question have both 2005 and 2008 reference so didnt really know if that would effect anything. And since i dont have a 2008 (let alone an R2). Hard to test.
I gave it a try on 2000 and that was faster for me (like 70ms +/- 10ms). Strange effect on 2008 i must say.
/T