Cliff Jones (8/5/2009)

---

Hugo Kornelis (8/5/2009)

---

You'll see that after the TRUNCATE TABLE, the space used is zero - but after the INSERT INTO, it is right back at its original size, even though Column2 has already been dropped. Only after creating and dropping a clustered index (or creating, copying, and renaming a new table) will the data size of the table be reduced.

That's very interesting. I would not have guessed that it would work that way. Thanks for the clear and concise explanation.