mark.hall (11/3/2008)
Thanks, JonathanHere's the data I'm getting back.
What I'm wondering is what does it mean when theres a "(0)" in the index name column.
Mark, from what I can tell in a SQL 2000 VM, it is the clustered index. I base this on the value of the Context column returned by the TVF in a SELECT * query. Lowering your fill factor would probably not be a bad idea on the high splitting indexes to allow more leaf level space to exist in the index. Be careful how far you go with this, as this will cause you to have to do more reads from the database to get the same amount of data since the pages maintain freespace in them to prevent splitting.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]