On SQL 2000 it never seems to adjust the free space amounts properly until I do a DBCC UPDATEUSAGE. And it never reclaims very much free space until I do a DBCC SHRINKDATABASE. But I would recommend a DBCC DBREINDEX before that to make sure the structure of the table is optimized. I think that will give better results when you shrink it.
Of course, I don't have SQL 2005 so it may work completely different. Chad Hall (501) 342-2650 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dave Barber Sent: Thursday, February 21, 2008 8:50 AM To: [email protected] Subject: SQL Server - indexes question ** Quick AR/SQL question : When you delete an index (or in the case in question, all the indexes) on a form via the user tool, do you have to run a reorg on SQL Server (this is on SQL2005) in order to reclaim the space that would be saved from the deletion? I've deleted a bunch of indexes on one table, and there has been no obvious space saving. Regards Dave __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ************************************************************************* The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. ************************************************************************* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
