SQLTeam.com | Weblogs | Forums

Reorg vs. rebuild indexes in a job or subplan task


Hi Everyone,

I know this is an old topic, but I used to have access to a script that made this decision for me based on some parameters and I'd put a call to it either in a job or subplan task.
I did loosing the drive were I had the code/script (external USB), now I just wonder if anyone out there has come up with the same approach or a better one I could make use of?

Thanks in advance for any replies...!





Even better than Ola (in fact, much, much better IMHO): Minion ReIndex


Thank you guys (Tara and GBritton) I will be checking this solutions shortly since they are more involved than what I had in mind (probably wasn't as good yours!)

Thanks again,