From: Hoardling1 via SQLMonster.com on 4 Aug 2010 16:15
What is a way to get the number of pages for each database's tables and
indexes, so I can see all the number of pages and size. Just trying to
streamline and check for fragmentation in indexes, and I have to either
individual go through each database and go to each table and find out page
size or is there a way to get everything in one query.
Message posted via http://www.sqlmonster.com