InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 22:52:26 GMT20http://www.sqlservercentral.com/Forums/Topic1382454-391-1.aspxIt also depends on other factors as well, such as:SP version and service pack levelwhat databasesSharePoint included a procedure called defragmentIndices after SharePoint 2007 SP2.Thu, 08 Nov 2012 07:50:19 GMTJoie Andrewhttp://www.sqlservercentral.com/Forums/Topic1382454-391-1.aspx[quote][b]hs24 (11/8/2012)[/b][hr]There is a good post in relation this at[url=http://blogs.technet.com/b/patrick_heyde/archive/2010/05/27/advanced-maintenance-for-sharepoint-databases-defrag-update-index.aspx][/url]and[url=http://blogs.technet.com/b/patrick_heyde/archive/2009/03/31/how-to-defragment-sharepoint-databases.aspx][/quote]For clickability[url]http://blogs.technet.com/b/patrick_heyde/archive/2010/05/27/advanced-maintenance-for-sharepoint-databases-defrag-update-index.aspx[/url][url]http://blogs.technet.com/b/patrick_heyde/archive/2009/03/31/how-to-defragment-sharepoint-databases.aspx[/url]Thu, 08 Nov 2012 07:26:55 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1382454-391-1.aspxThere is a good post in relation this at[url=http://blogs.technet.com/b/patrick_heyde/archive/2010/05/27/advanced-maintenance-for-sharepoint-databases-defrag-update-index.aspx][/url]and[url=http://blogs.technet.com/b/patrick_heyde/archive/2009/03/31/how-to-defragment-sharepoint-databases.aspx]Thu, 08 Nov 2012 07:24:12 GMThs24http://www.sqlservercentral.com/Forums/Topic1382454-391-1.aspxYou can - we do too. We found that the timer job that rebuilds indexes only rebuilds an index once it becomes 30% fragmented. It never does any sort of reorganization and this became an issue with some of the larger tables since 30% of the fragmentation would be 10s of GB.If you Google "sharepoint index defrag" you'll get a lot of good information - including what steps you need to do to replace it with your own.Thu, 08 Nov 2012 07:19:16 GMTtafountainhttp://www.sqlservercentral.com/Forums/Topic1382454-391-1.aspxYou will need to provide more details - SharePoint relies on a number of underlying databases, if you want to rebuild the indexes within those databases, you probably can ... but it may have an impact on your support agreement, you will to double check that just to be sure.BThu, 08 Nov 2012 06:24:39 GMTbleroyhttp://www.sqlservercentral.com/Forums/Topic1382454-391-1.aspxis it possible to rebuild indexes in share point server?Thu, 08 Nov 2012 06:18:11 GMTramyours2003