|
Author:
Author Bio:
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.
|
|
|
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.
|
Video Information
|
Publish Date:
|
September 09, 2008
|
Length:
|
3:30
|
Skill Level:
|
200
|
Rating:
|
4.16 out of 5
|
|
|
|
|
After watching you should be able to answer these questions:
- Which method is used to rebuild the indexes?
- What value would you check if you wanted to only rebuild indexes above a given percentage of fragmentation?
|
You must be logged in to view this video.
|
|
|
|
|
|
Comments:
|
|
Great demo.
|
|
Joe Pattison on 12/19/2008
I got an answer wrong - but what was the right answer?
|
|
|
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
|
|
|
It's very cool, but what is SMO?
|
|
Mathew Somers on 3/10/2009
SMO rocks - nice pres -
|
|
|
Awesome!
|
|
|
doesnt work -- Trying to view and this popped up
|
|
|
|
|
|
|