Displaying posts written in

October 2009

Oct
6
2009

DMV Report for Index Fragmentation and Statistics Update

Recently the ETL load times of my Datawarehouse are increasing and so I decided to check the Indexes status on the tables . I found some fragmentation on the indexes and also some Statistics that are not being updated regularly . I searched online and found this blog by Ben Nevarez(SQL Blog). I decided to [...]