the following scripts helps in finding top 5 missing indexes using the new feature of DMV available in SQl Server 2005
Updating all the indexes/statistics of a database
The below command will rebuild all indexes on a database.We need to run the below command in the context of each database that is of interest.
2007-02-21 (first published: 2006-10-23)
1,218 reads