Rebuilding SQL Server Indexes Using SMO

Are you rebuilding your indexes at least weekly? You can do it a few different ways; maintenance plans, custom scripts, or if you like code, you can use the SMO library to build your reindexing routine! Tim Mitchell, our resident SMO guru, shows you that a little code goes a long way when you need to rebuild your indexes.

Tim Mitchell is a Microsoft SQL Server database developer, business intelligence consultant, writer, and speaker. He has been working professionally with SQL Server for over six years, and holds the MCTS and MCDBA certifications from Microsoft as well as a Bachelor's degree in computer science from Texas A&M University - Commerce.

Leo Njampa on 12/19/2008

Great demo.

Joe Pattison on 12/19/2008

I got an answer wrong - but what was the right answer?

Chris Rock on 12/19/2008

Joe... We realize that is going on. I'm going to fix that "feature" soon. Thank you for comments!

nyaknoabasi on 12/19/2008

great love it keep doing what your doing

Leonard Peoples on 12/19/2008

It's very cool, but what is SMO?

Mathew Somers on 3/10/2009

SMO rocks - nice pres -

Tonci on 10/9/2009

Awesome!

M McDonald on 1/5/2010

doesnt work -- Trying to view and this popped up

Flavio Cortes on 2/17/2011

Cool Video

Dan Feiling on 6/3/2011

can the same be done via powershell?

G on 6/3/2011

I don't know when you added the little quizes at the end, but those are a great addition. You can just feel the new wiggly little neuronal connection solidifying a bit... THanks!

karloz on 6/3/2011

Excelent! Thanks!!

Misael Chuc S. on 6/3/2011

Cool!!!

WChaster on 6/7/2011

The code download did not have the script :(

Maurice Ivory on 11/4/2011

I learned a litte something from this.