February 2008 - Posts

• 2008: Rebuilding a Heap

  In 2005, rebuilding a table that was a heap (no clustered index) wasn't easy. You could copy it to a different table, or you could add a clustered index and then drop it. In 2008, this is a far easier thing to do. They have added to the ALTER TABLE command Read More... Posted Tuesday, February 26, 2008 11:10 PM by drsql | 7 Comments Filed under: Dynamic Management Objects, SQL Server, T-SQL