Hi all,
After reading this article[/url], I was wondering if there's a difference between using ALTER TABLE with the REBUILD option and rebuilding the clustered index on that table. BOL is not very extensive on the subject.
Furthermore, I was wondering if it is necessary to check (and how? Counting and comparing columns from the sys.system_internals- and the sys.columns?) if you need to rebuild a table, because as I understand, a lot of space can get lost after performing DDL statements.
Thanks in advance!
- Alex