Auto Rebuild Indexes

This pair of stored procs together will allow you to defrag/reindex all the tables in a database that you deem necessary, based on a fragmentation percentage you pass in as a parameter. It also keeps a "Before" and "After" history of your tables' fragmentation with every run, enabling easy reporting on this regular maintenance. Run this as a scheduled job to automate a good portion of your job of keeping your tables streamlined and healthy.

SCRIPT: Auto Rebuild Indexes

PKaE< ReIndexHistory.rdlUT
PlKX`uxiH.?iڹb 1e$VAb	(3+̪}zV"ǃ~sݜ¦M_?Bo/㱋>}g5ʦM	~S)2>eh[IY=nj[i\͏wM}ڗ @衽(-n0on~cmXx/4QeQMSVCL54O<+y"yߒ5Ӏo.w	84^,D K(pxxFK\834T͝b4̂gJ-?@-{I}2nkqWLn:	}KC#_tsjtlP~RyAW}Ax~WK6noRoRG
D݂67D{E~/G?̅$S_oAT5<~Ѩ0ja=]/t|{X.Mq
SoϾYY~S?ۆzS?c/]m	yJ^CyO#1~sy_JO7O秛[rlӇ!৛ͣtb6M;IBByڛ?Z鼌âs//֊Q'ߐn1r&:nK	-akf~v5Dvظth7v^yVܯCL7;=x[3p'/yg8{U|0 ^V=#$0ڐ%!ݗ|!yse/QJ6)&z6&wiOuN?zS\J/Kʳ7q䭡?zG,^W6<1uCuKxlfݹYfV-LN
g ޾nUKd.~&JךUwc׏SoWzY=;Geוt睓_GV+4^!
=B7jx* !Wڿ+?fwkNTuo6t3Ly+?5EUoZ0{9N;G' {Gw59t+|˱o}o]
_C[]W`uU=+=
x/q_*~ܿ^}ᛛ=v/>A5-ȓEH?My,ީ)Æu׀c+'4
~<}
Iu$L!rE?~{b߽rgblcWp_s֚-=t~#]}}?2BM`c%)^y,^Y}˘6vþ.{z=y/hyxB5#/x
__$<]C5^h~zUkaPE5^C_Vo=yW
p%;,mIyҭ7+~O4gor%M+M~+>CbBۮnù^kOʟ=fxϞJma|/fw~yfڦ^M45 {pl:^yk:|[[;V_Vۭ%//\?|_o
q>H~;1\5a{yR;P_J6eȗZtKok^Z)f/{3V[f8u`(nIvɝ'Z·i_z"vn?A8Tr	_av{\^=zCz۷\xrApxqz|G?Krx	/^%/y%y=T"|[tI'^$;7SwO7n/OMW˱n˛TnVBJ7w/j	9޽$+o$I䱛[>%(oiY7W9޵|l;=n_޴~VMԔ;_:vN){]>Y[t7L6p:7*g#ʴsv.	c|32tq}_CߡLo~߽7!_)]RηL\$yuY䭅{_
WZHܹ//TU	.3MON*=3Ml~jJr-K\jﱽ0\0}YZ>
[4gwoi+AߢGoO#=ӹ%a{RFw7߱=ߺ\=r[0=y+oHg?>_8Ԁ>a;7um^pk~ĖShaWexXB=Ԃ_C+μߊ3|t.fk){KX$wXxA`q"A!u5 s.8A_g-q?5yXO,m&:w{[K}wo|X-x.wB L o@^	_)hUw_4az۫	^")?F1R_yv-o:/Jzx(C/fO~[~c/ddZtM{Hk_΢7͋0}N=g%ϗt_]+\\=i֕q }vO.ZO}>} Ñ/}Q_	or_FwU~/[TŋFﺹ:޹7޽Y3 8	ܔ͏w7ŜCxq,7A0x_5MKoNwyl,N]{78o\
}79>	]x{6[\K^2~vR}ubrB_S滊BE.~QnIv8->Ag&xQS2ҞJݹo!Pd#΅ީ'?SOϨzOe2cAGGfzItI3zE{r28$kXW-ZvƥMpYlOjHе䇟\V*s
h0?$Y?V{Ӈ94'!?\($XK:y:J#seyd̙ɛtɳζLޱ奍uL%ė(oTPM#wg3Q'OXvq|s>W\m6*:S6mf*U6UbVj&={Z[jM~ϛ3j?*W\m[YZr&f*U6䷶ɟtjwrɟ>M~LZw&W֟~_*W\m[waWJ\mroyg_YjM~ka+rW|U6|LZ&W6]U6䷶o0ӿ*Ծpy?݌I l$,I,268jdlTߋTN~K|0DĆ{9o
,ܹV+eZʘܯ"
R'`&T 	,Ċ H৾g+0xot:6MncVlSK&̊"yX+dC6yG8]l>BGΤ?*`ڵ	暊-);W Kwx1ˀ
`*q{ߋ2l3dѳJV6`~h~)mˬڤSr1ETc=p	CPVV	zI`ULT%ط"2ƕ=z9{	_rt$t"r)lE<1]ݭ}E~@
kebZzyM\>+RfiT†06#i0v^h
eUB6uwewDT+LZ;AFR89r`(\x$6(Mg0dɆVh@Ü:'lKfE_(љvզFN̩n1κ|. )ϳAB3lL)r;k}8<}I:P@L6ւi!RO@'"uuEVYjzᆘK_w:s<+Ҙ-g	ߪ{z|pҒ7kwcl{V$p;Cl7M)hӔ}75wEN29'˓c>x)g(ZuF9hWOu"z:{!;@%"+IUz\{?+ݵCmNYXz:R<.BKuU]9φỵ*Mg
P@\HDĥ10[=.ˬ/`lVҫS\WFqB"
]ͽQ6͜xsEd|Rc/ֹ%asg ?թ1P
"ޭ3YyTBow4b0Ey7LhC6;ԛ0b:X!	7jcjΦz~xʤH|J=MˉBwlr%U!:B{UYQf	",(quöPGzѭ$4]ΚA?q>*`T.Rk*qae"ch	S=Sc$͎VZ!1nnEhOP|Chs`}	z82$H6QhNWǔ]O3SvueڃY.ýG:sC;h`]RE]:
:~8S8ЏDIr3V9O.OUbS~)R	3?a&(dMZUJsy8@\
$ubu.ld:N`A UQٙեÛ9a~D9H+*(DE2mfPS4gz\gn2͌FOLj0KlLWĂLSЭ7oAD~Ls$ެ՞5t4|5 nY5$rnxr@EmqUa+	|qmr3ORh"V>;sJ4h%:?X-T~7Z&rfAN5g^or:
ݥb*sSN1XZ4ό.'Z(k=9K-,"LtցllX0x
\ֱA;;V+h"OLCA
F	ih|M:sZ+%	c݈Hr$rS]Y*Wlb},*`wyzqa5Jm~Rwт=5Eǹ+B5i=_U?9jY(~fSE5qm5XNzLmid͓L3e93P3?Xup	"gNw;:d7Idj# TZ;vA鑺Pbbjk!uq$fkxIGJ{wQgsusi݁wRЯ&
켯krnP5J)SxZKyGk.5-5l=DE	Ejl/y>ŪTO7JvQh5@B+K,C	N1tEA_ZKFy9c+B0Wr&vdeã8wX֤?=n:a1쏤n8] -΀6rf֖]	vEP<ȓm!Pg_@䘦we;.g.E`p	aLܶf\+b{BU3Do	66_0>;UQ4vmbLHRY\eH2ܸL*bskdz!1k
Gur!E
Օ߯X"O4hGKNⶭX\
{[
KFv[٧Ȋj;P 5s	+p1z#oZ[j.C1hG2Uxs`υhY0'%*?\`usg{a(ezL;\R~feŶEԠ`QgkH=!(mW5K7`y)Y5f(B&g>v^E*Cg
cʐ`*袍PhˉpRyny ݺDu`xїLMඁMN9
Sd|jqZZ%Fk:6P88\-Kt?pnkZP%Yj#!{B'z4c-Ww
E=fuko4c]Lw,c(yDavق@91uqs7V)}$jb}]n.iU:Y2
5C
dݢyZI+PS*O{lozq@"*e9?cQ`mO͵h"|mXsJm)0jn`H7
)e
+ioԂ\ʧ,9oP{f\KtftSJ́m
M-w@Ovf|oU#vAIύLyXեWxL
U1?kg6^+5mKZEMޕ(
;;vv97ImԏB1i6Zb>'e1J bqE=*:T{a\
5@Ri.B^2fY򰟷u9	Y3-uuIb!0RL8:h&u3)t.oHꡉ8O자u-܅:ϮGzb(XFe:ȪK<:e,Slj;(,>GmM@y&l5T~Ô]
jʹeg 4}5Wnֆ*CeNE#jَOs8a$5"QYt;V}PucuU6Bn$S]gKєbQ֬'&(M!CPt#A>IZ0f}yt;cvTv뒘+mxv
9jda8̵)۷?Wx
;1
3Sޟ'gF]KM2i
TD-,"l̐qZ/MJy0DAʃ-
fq&fjaU;}'~Pw&>BW5ky)|tzz zkD3+xv>.`<\xkR3'BH99\@G>V>]Xѳ4WQRgB)a>e!V^da2gnPu:̖/Ny6+b-.lͥ9[1)٪{\GAV'giXY
'S,(ʑTq=]>oT]ytAOأ>		*宷d,TNO'}>,h6|RC_P./w_clt蟓XeA-9|QuN=P/V)'DSK?+|w6[֘@X4X=~~O~WQGvݲ
J!	Tyh{,o0w;PL<@V8#60"b`QWW	VBS"0f}~X`ǘp٤4a5y,_Ovpn1ϑV\Ʈ6%Kl"|q4XHzI<ؕcʪC>Go\DǼ0s㤛#iʌ~._r:<ؤcoRM
=͠!B綴<K{X**#YSӴ`;QʥIkCc=#۲Fc­Nwj׳ʊq8\X&ZfnS
Q5KmB$D[ALs)n0AH*֫)e#DOp4YF=gu/^o$A>8.*I`~dsw=X^Ncd>Öq>Aw"[N)FM(V+OTa/cWk
$0L.-_hVv0!YGjrČ8/PoH&0Ô	͚7O{%Ձ߻TS91$ye(wLD61i\lᆃ"+D\TJ! څ[汳Ni{סm#=gs*4GN@p~@THs9cq,9[8нes,#G0X
>6MS0rvH4Fot&ت
F<#k6͗GrلM5Qܹ{NGa4Ғ1;v%nURB
VKl2ֆ4waҜܺg;AG4akf"!$\<]Y;Dt#SC=˃v$p9\yQ2c7d6R5MȣO=94uzyDsiJ\22%1gȈɨXH!km%-iz_%/'i6|[kKhUdʩA݀VFۈX:	x(
,MpϊĔR;T,1|Dq{Teg8_2u	:{NeB'MmsZعPP*eݚ
J@fK|^-1NP**BDpj.J
lrT9'c #>)DU4*J$ĕSlmebÀHGycfJD0&6(ifcA8BYY_6@πI'\F{}/kZ/73~jPdƁ*b\[.]”8z$.`DEv§[8*ns麂&ޡ>҉XF83~pks%1EiUX]P:9_n*S?2Sgr}.֐_K,ۚZn!97զõn#F10OچC>g;s*Vg>[m6עas	иU-`uH6Z<Z5R;8sDÊ}MfnjJqGwkj%ܸ\aoDRD
9az(je*{;o]XƜ/v<8pA<U3$biNٌ
|ih yu4V)M	 ĪY!}I'Νc,4;eG=lmghdkZvE*v̩vlF9˨O#Z-h+
g
oU]?7?GOB"a@xwb ZA.Pgϛ0}:_?}PKq29PKaE< __MACOSX/._ReIndexHistory.rdlUT
PlKX`X`uxc`cg`b`MLVVP'" 0CBL@l!.XPWXXWPo``ahmf`hllfjQjb`baifbaikhfdjf
F.PK7-lPK}vR% uspReIndexTables.sqlUT
X`X`X`uxZkoVli
$t(jYJ4 0XSG3sIihD1wgf.svz+E]tG$7bJMz}xadOVʣZęfzyCiζmG6:.f;{VNX
3_1{'qJ(8rJJW*A]a<;˳X>a%"P	!99xsETvzJ)TJQ#{rVa>7*ve	捓h	oYT Q
OT9GzX &۱66QaUꯕg!p/9qpQ6Q)k2V,pbZ;~	]EI`17.;V'.E!5sQce}4w&&^Q/^?P)\ECWQ
M#vwEMg>#aEGLZ^FB(~R:5Iގo퇈X3gExRcEMkk09D~f
s$%"zIxp]:GW|tiU"& SZ
fNWp" "[6r;h`pdh:z7'|?Oflnf>yTDbobFxA['L\gjw{	%XE8FG'vWN|w.a9;_+!:"^qqP%j +O
JS,Eu(:m2 t)bqGߞKg.Ċ(FK>Brt/ۇCPYaxyL^sCK	ԭL"CpYON͓M֯=N?s@pHJ{hh9ϗl0SS:@lv/)ч\w$O@Qt?Jʂ}tɆ Fl/tЪ?fDMp%Z7Ԏ~?RO_Cn<	&A(XyzG-w'4QSs`!9CX]*k^'_pٟ>aj񏭼Dޏ2fMi%GKEҁI8$K [sеE+!i:,(Ր;kHYe2f6Gvr`L*a89Ib\&=A@m'g3L!QT#SOaǤ
TH¤:`(N=ZZ[z̳]ss[ߜatF8@2yZ51;P}Eu?̋Vq
esQXޱEo7YE
	?9C7Nu4Q{;L}L>\M&CITKE6יT)Vk1;%GѤt7źR)žb UUlY+]uG#6{&]
o[x,bNŵ)`[(鲴߳oQ|ܗ݆LH#6]:8;$&
뢯f}*|޻↥7<􉇖R#[߂uyS@H\3F,ICҫ2buU"/=:7}F=K\`4uNs/ahㆠL!e?xIä7.CN/e_3EcY=`){AHwl
qDf}7g|˗
|	,7V5@&7wyı!휝Fʞ,#@?gUV]|+RNvKT]u0FOi̚[C>v(KVm8߽+4cWO2p6X8j7Ҫ={7E7:{//(	{^
_uu6j4viNp7EY}?2[i7fuh筪(Kn$1OqۚlW"O/NewFxvP<

[T^pZFCXk&VH_ɭ\)B<">I-ͅvr]d[5"d١s¨a91IiG+iT?g=Q'cEh+z gRGTLWY[/8tO7u77+ѼH%\/o=35Ldw8:YWڳ[xζEqup?\?w@|/K!VaXFmTrH:D+R^62T^G/)7/Am]MH]qiVlz_חJ?0 PKRn %PK}vR __MACOSX/._uspReIndexTables.sqlUT X`X`X`ux c`cg`b`MLVVP'100@>-cHHhd,BSg`OK,(I I(qKOKw R59%ũ))%P{ B]njI"PMU|gIjnhqjQHbz1X}#d`0Ǣ'1)5'>%Ǩ04$9)$ȼ0<$M Kɂ褂P2B=a|G;|Y)C'ߏZ?Y*QeįX}w 4{vu0?-m\xV[nMbX+}W,PK \KPKaE