Backup, Integrity Check and Index Optimization - CTP

Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization  (Best Free Tool - Gold)
scripts, a solution based on stored procedures, functions, sqlcmd and SQL Server Agent jobs.

He makes some interessting Updates for us - in his new CTP version of IndexOptimize!

  • UPDATE 05 Dec 2010 - New CTP version of IndexOptimize with the following changes.

    Support for updating of statistics with the option RESAMPLE. Set @StatisticsResample = 'Y' to use this option. - Thanks Ola  :-))
    Update statistics using NORECOMPUTE on statistics that has auto update statistics disabled.
    Only query sys.dm_db_index_physical_stats to check the fragmantation if it's needed to decide what action that should be performed.
    Support for only updating statistics when the data has been modified. Set @OnlyModifiedStatistics = 'Y' to use this option.
  • UPDATE 01 Dec 2010 - The most requested feature in IndexOptimize for a long time has been support for updating of column statistics. I now have a CTP version with this feature. Here's an example of how you can rebuild or reorganize indexes with fragmentation and at the same time update the statistics. As you can see the new parameter is @UpdateColumnStatistics.

    EXECUTE dbo.IndexOptimize
    @Databases = 'USER_DATABASES',
    @FragmentationHigh_LOB = 'INDEX_REBUILD_OFFLINE',
    @FragmentationHigh_NonLOB = 'INDEX_REBUILD_ONLINE',
    @FragmentationMedium_LOB = 'INDEX_REORGANIZE_STATISTICS_UPDATE',
    @FragmentationMedium_NonLOB = 'INDEX_REORGANIZE_STATISTICS_UPDATE',
    @FragmentationLow_LOB = 'STATISTICS_UPDATE',
    @FragmentationLow_NonLOB = 'STATISTICS_UPDATE',
    @UpdateColumnStatistics = 'Y'

Please feel free to contact him if you have any questions.

I wish you a nice  day,
tosc