Rebuild/Reoganize all indexes of all databases

Question

Post reply

Rebuild/Reoganize all indexes of all databases

adeilsonrbrito

SSC Enthusiast

Points: 113
More actions
April 22, 2010 at 1:21 am

#223733

Comments posted to this topic are about the item Rebuild/Reoganize all indexes of all databases

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Abrar Ahmad_ SSCarpal Tunnel Points: 4244 More actions · Answer 1

[font="Verdana"]its English version please? ..... just joking !! 😀

Nice Work[/font]

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 2

Had 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?

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 3

I have written this logic using sp_msforeachdb.

I need to ask Why have you used this condition

p.page_count >= 10

Is this to check if the Index is large enough to Rebuild or reorganize or any other reason?

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

sdesai SSC Enthusiast Points: 141 More actions · Answer 4

Nice 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.

Paul White SSC Guru Points: 150467 More actions · Answer 5

http://sqlfool.com/2010/04/index-defrag-script-v4-0/

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Shamshad Ali SSCarpal Tunnel Points: 4822 More actions · Answer 6

After 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 help

Shamshad Ali

slash.ricardo Grasshopper Points: 21 More actions · Answer 7

Hey guys, the language used is Portuguese (Brazilian Portuguese).

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 8

HI 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?

THanks