This is a simple script which would list sp_helpindex information for all the tables in the database. You dont have to provide any table name or anything. Just run it on the database from which you want to retrieve the information.
This is helpful when you have several servers running the same form of DB, and you want to compare the index information. I used it to compare 7 different servers running the same database with a model database. I wanted to compare what indexes are there on what columns. You can transfer the results from every server to an excel sheet and compare each table's indexes across servers.
Rebuilding Stats: Twice or Not At All
Are you rebuilding statistics twice on your tables? Longtime expert, Andy Warren, shows why you might be asking more work of your SQL Server than is required.
2008-07-29
9,130 reads