• Good Article. One thing that we learned the hard way is that size doesn't always matter but often times volume does.

    SOmething to keep in mind. Also something that was taken into account with SQL Server 2005's canned reports. Very useful when troubleshooting issues as you can see your index and table usage stat from a hits perspective as well as size.