|
|
|
|
|
|
|
|
|
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.
|
|
|
|
Duration:
|
3
mins
30
secs
|
|
Skill Level:
|
200
|
|
Rating:
|
4.21
out of 5
|
|
Publish Date:
|
September 09, 2008
|
|
|
|
About the Author
|
|
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.
|
|
References
|
|
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
|
Must Be Logged In
|
|
|
|
|