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.

Viewing SQL Server Indexes using SMO

In this video you will learn how to view the indexes in a sql server database using SMO

Video Information
Publish Date:	September 09, 2008
Length:	3:5
Skill Level:	200
Rating:	3.98 out of 5

You must be logged in to view this video.

Rate This Video:	12345
	1=Poor, 3=Good, 5=Excellent

Comments:

Jon Jaques on 10/28/2008

Useful video, but no mention at all as to what "SMO" is.

Chris Rock on 10/28/2008

Jon, it's short for SQL Server Management Objects. You can read more about them at http://msdn.microsoft.com/en-us/library/ms162169.aspx

Mark Gelatt on 10/28/2008

great presentation skills.. however the title implied this was how to create indexes, not report on them. It's still good stuff - just mislabeled.

hades on 10/28/2008

This is Excellent JumpStart tv Rocks!!!!

Carol Quaid on 10/28/2008

low volume control

Jeff on 10/28/2008

Actually, I think a video around 8 minutes is a proper one.

John O'Sullivan on 10/28/2008

good demo

Paul Kirkham on 10/28/2008

Very good method, would have liked an indication of what we do with the information e.g. some reference to another video or documentation on index fragmentation.

Terrance on 10/29/2008

Very good lesson.

Michelle Poolet on 10/29/2008

Points off for mis-naming the segment: a much more accurate title would be "Creating a Report on SQL Server Indexes Using SMO" Points off for screen resolution: need much higher reso.

Chris Rock on 10/30/2008

I mislabeled the title. It has been fixed!

Frank Kirk on 2/6/2009

a sample of the code to download would be nice for those who do not program that much. Thx for your work.


Must Be Logged In

References

Code from video

Download the code from this video