tag:blogger.com,1999:blog-5849265.post114915997816970300..comments2023-10-29T20:45:15.971+05:30Comments on Vadivel's blog: Reclaim Unused Table Space ...Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5849265.post-51349818282732415032008-03-06T20:34:00.000+05:302008-03-06T20:34:00.000+05:30Alexander, I have written couple of posts discussi...Alexander, I have written couple of posts discussing about those in detail. I have now linked them under 'Related Links' section within this post. Check that out.Vadivelhttps://www.blogger.com/profile/13387133927257826888noreply@blogger.comtag:blogger.com,1999:blog-5849265.post-68377467372356691722008-03-06T20:04:00.000+05:302008-03-06T20:04:00.000+05:30Just in case somebody, like myself, will stumble u...Just in case somebody, like myself, will stumble upon this post trying to find how do you reclaim space after dropping a fixed size column here it goes.<BR/>If there's a clustered index on the table you can use DBCC DBREINDEX on it. If not, then a clustered index can be created and then dropped - it also should do the trick as both of these methods trigger table rebuild. Unfortunately both only Anonymousnoreply@blogger.com