InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 15:19:58 GMT20http://www.sqlservercentral.com/Forums/Topic908356-2673-1.aspxHI SQL Kiwi Just want to know if the script through link runs for Index Defrag so we have to run Update statistics separately or whole script takes care of Update Statistics also?THanksSat, 28 Jul 2012 09:49:16 GMTlogicinside22http://www.sqlservercentral.com/Forums/Topic908356-2673-1.aspxHey guys, the language used is Portuguese (Brazilian Portuguese).Thu, 09 Dec 2010 11:13:49 GMTslash.ricardohttp://www.sqlservercentral.com/Forums/Topic908356-2673-1.aspxAfter applying the alter index, out of 10 there are 8 alter statements are same - actually i ran this script twice to check there is no anything missed - so i want to know either alter with rebuild or reorganize both ran multiple times and your script suggest me to those alter statements agian and atain - I want to learn why those are not updated? where is the problem? are the indexes not properly implemented? Please helpShamshad AliFri, 21 May 2010 09:14:16 GMTShamshad Alihttp://www.sqlservercentral.com/Forums/Topic908356-2673-1.aspx[url]http://sqlfool.com/2010/04/index-defrag-script-v4-0/[/url]Mon, 26 Apr 2010 05:22:08 GMTPaul Whitehttp://www.sqlservercentral.com/Forums/Topic908356-2673-1.aspxNice article.I have taken exactly the opposite approch :-)I start out with finding all the indexes which are fragmented (30+) and then rebuild dynamic sql to actually rebuild or reorganize. These results into two sweet and short SPs + I log everyday what I find about this indexes. Mon, 26 Apr 2010 05:12:56 GMTsdesaihttp://www.sqlservercentral.com/Forums/Topic908356-2673-1.aspxI have written this logic using sp_msforeachdb. I need to ask Why have you used this condition p.page_count &gt;= 10Is this to check if the Index is large enough to Rebuild or reorganize or any other reason? Mon, 26 Apr 2010 01:31:16 GMTAtif-ullah Sheikhhttp://www.sqlservercentral.com/Forums/Topic908356-2673-1.aspxHad to change to run in SQL Server 2005. Just changed the initialization of @Loop ,@Qt and Total.Nice script. Just want to know Which Language?Sun, 25 Apr 2010 23:56:22 GMTAtif-ullah Sheikhhttp://www.sqlservercentral.com/Forums/Topic908356-2673-1.aspx[font="Verdana"]its English version please? ..... just joking !! :-DNice Work[/font]Sun, 25 Apr 2010 23:38:37 GMTAbrar Ahmad_http://www.sqlservercentral.com/Forums/Topic908356-2673-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Reindex/70060/">Rebuild/Reoganize all indexes of all databases</A>[/B]Thu, 22 Apr 2010 01:21:46 GMTadeilsonrbrito