Thank this author by sharing:
By Tony Trus, 2012/12/14
This is a retooling of Thava's block of code that he shared with us in November to count the number of indexes in all tables and is designed to build on that output to better understand how it contributes to storage requirements. I arbitrarily chose to sort on the total table size but left a commented out line as an example to switch to sorting by total rows.
If anyone can think of any tweaks, changes, or questions please enjoy building onto it to better the community
Tony Trus
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
