Jayanth_Kurup (10/11/2011)

---

I think; before looking at the speed you need to understand the impact it has on the actual table definition.

Collations and datatypes etc will come into play when the temp table is created explicity while they default to the tempdb and the source table when implicit.