Any one has scripts to automate DB Index rebuilding. I dont want to run rebuild all the indexes in a db but i want to rebuild only those which are fragmented and which really needs to be rebuild.
Here are a couple of scripts that should help you build something: http://www.sqlserverexamples.com/v2...dexAllTablesinDatabase/tabid/175/Default.aspx http://www.sqlserverexamples.com/v2...dingIndexFragmentation/tabid/170/Default.aspx
[quote user="Greg Larsen"] Here are a couple of scripts that should help you build something: http://www.sqlserverexamples.com/v2...dexAllTablesinDatabase/tabid/175/Default.aspx http://www.sqlserverexamples.com/v2...dingIndexFragmentation/tabid/170/Default.aspx [/quote] Hi Greg, does your site require registration? I'm always redirected to a login page.
Yes the site does require registration. It is very simiple to register, and it is FREE. Once you login then all the examples are available to you.
[quote user="Greg Larsen"] Yes the site does require registration. It is very simiple to register, and it is FREE. Once you login then all the examples are available to you. [/quote] Thanks for confirmation. []