Check how are your indexes doing in the database. This script is very useful when you are doing some performance optimizations by creating new indexes. Or trying to find some...
Get information about all existing indexes in given database. This script can be handful when you want to check all indexes with their create scripts and some of useful information...