Editorial:Two Great Webcasts on the Near Horizon Read thoughts, experiences from around the world, hear about other's work with SQL Server and much more. Read More...
Rebuild or Reorganize or do nothing to indexes SP The following stored procedure makes use of the index fragmentation information that resides in the dynamic management view sys.dm_db_index_physical_stats.it decides according to the pecentage of fregmenation if an index is to be rebuild, reorganized or left as is.