• mark.hall (11/3/2008)


    Thanks, Jonathan

    Here'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]