Using the IndexProperty Function

Want to know if an index is clustered, disabled, or what the fill factor is set to? All you need is the IndexProperty function, the ID of the base table and you're almost there. It's easy to use, and did you know that it works on statistics too?

Duration:	3 mins 14 secs
Skill Level:	100
Rating:	4.28 out of 5
Publish Date:	February 18, 2010

You must be logged in to view this video.

12345
1=Poor, 3=Good, 5=Excellent

About the Author

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

References

Books Online - IndexProperty Function

Comments

Ranjith on 2/20/2010

informative. Thanks

Babita Das on 2/26/2010

jjjjjj

Martin Miller on 2/26/2010

Thanks Andy. -Martin

Must Be Logged In