March 3, 2005 at 4:21 am
Having run dbcc showcontig against a table which is a heap, how can you defrag it apart from physically moving it to another filegroup?
March 3, 2005 at 4:46 am
See if this helps:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
March 3, 2005 at 5:39 am
Just for giggles...... Did you call the Garbage man to clean-up the trash heap?
For those who don't get the reference (Oddly I get this a lot) "Trash heap" was the all-knowing wise one from Fraggle Rock and "Garbage man" refers to the all-knowing wise one in Dilbert.
Good Hunting!
AJ Ahrens
webmaster@kritter.net
March 4, 2005 at 3:21 am
Create a clustered index on the table and start moving in the rigt direction from a logical desigb perspective.
March 4, 2005 at 6:57 am
athurgar is right. Create a clustered index, then drop the index to return it to heap status.
------------------------------------
create clustered index CookieMonster
on
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply