September 7, 2007 at 4:14 pm
what are the SQL Commands used by the optimization section of the maintenance plan?
specifically to "reorganize data and index pages" and to "remove unused space from the database"
your help or leads are greatly appreciated.
thanks,
Les
September 8, 2007 at 10:49 am
You can rebuild indexes with DBCC INDEXDEFRAG OR DBCC DBREINDEX
Shrinking parts of the database can be done with DBCC SHRINKFILE
September 9, 2007 at 4:24 pm
One way to find out (I think) is to run Profiler [capturing certain information] during the time this maintenance plan runs ...
September 11, 2007 at 4:25 am
the maintenance plan runs a dbcc dbreindex for all user tables with the free space set to whatever you specify. If you set reporting tab to log to a file you can see what it does in the logfile it produces
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply