a number of SQL Server 2005 scripts he uses as part of his DBA
toolkit to analyse indexes including their usage and health. They’re a great
short cut to building your own after wading through BOL.

So far there are four UDFs he’s published that show the indexes on a table,
the size of indexes, index fragmentation, and usage.

Download the scripts

from here

In the next few weeks I plan to publish my set of dba scripts for SQL Server
2000 and 2005. Subscribe to

my rss feed
to make sure you get updates.