http://sqlblog.com/blogs/louis_davidson/archive/2008/02/26/2008-rebuilding-a-heap.aspxIn 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 commandenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/louis_davidson/archive/2008/02/26/2008-rebuilding-a-heap.aspx#5297Wed, 27 Feb 2008 11:57:05 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:5297joewebb0<p>Nice tip, Louis. Thanks!</p> <p>Joe</p> http://sqlblog.com/blogs/louis_davidson/archive/2008/02/26/2008-rebuilding-a-heap.aspx#5298Wed, 27 Feb 2008 12:03:40 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:5298Denis Gobo<p>I second that, nice one</p> http://sqlblog.com/blogs/louis_davidson/archive/2008/02/26/2008-rebuilding-a-heap.aspx#5344Fri, 29 Feb 2008 00:46:45 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:5344AaronBertrand<p>Ooh, that looks like a nice enhancement, good one Louis!</p> http://sqlblog.com/blogs/louis_davidson/archive/2008/02/26/2008-rebuilding-a-heap.aspx#12556Wed, 11 Mar 2009 10:25:25 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:12556Gokul<p>Rebuilding Heap is now very easy with ALTER TABLE. Thanks Louis. Nice Tip.</p>http://sqlblog.com/blogs/louis_davidson/archive/2008/02/26/2008-rebuilding-a-heap.aspx#12557Wed, 11 Mar 2009 10:28:02 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:12557Gokul<p>Space is not released after you delete some rows from a table. Why SP_SPACEUSED doesn't reflect the latest changes?</p>http://sqlblog.com/blogs/louis_davidson/archive/2008/02/26/2008-rebuilding-a-heap.aspx#28264Wed, 25 Aug 2010 15:02:09 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:28264Mark<p>First words out of my mouth &quot;Nice!&quot;. Then, I read the comments.... :-)</p>http://sqlblog.com/blogs/louis_davidson/archive/2008/02/26/2008-rebuilding-a-heap.aspx#36320Fri, 17 Jun 2011 04:40:04 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:36320Pasha<p>Good Enhancement.. thanks for sharing</p>