Jul 31, 2011 | Microsoft SQL Server, SQL Server 2005, SQL Server 2008, TSQL
Suppose you want to loop through all indexes and rebuild those which fragmentation exceeds 30 percent, and reorganize those which fragmentation is between 5 and 30 percent. Rebuilding or reorganizing all indexes is not a problem – you can prepare a maintenance plan... 
Recent Comments