SQL Server 2005/ SQL Server 2008 - Rebuild or Reorganize ALL Indexes in a Database
Posted by: Fervent Coder,
on 10 Jun 2009 |
View original | Bookmarked: 0 time(s)
I found this gem while looking at a database that needed all indexes rebuilt.
I actually had to create the programmatic way of doing rebuilding all indexes in a database based on the information in these posts:
http://blog.sqlauthority.com/2008/03/27/sql-server-2005-find-index-fragmentation-details-slow-index-performance/
http://www.sql-server-performance.com/articles/per/Analyze_and_Fix_Index_Fragmentation_in_SQL_Server_2008_p2.aspx
http://www.sqlservercurry.com/2008/06/rebuild-all-indexes-of-all-tables-in.html...