Prev: Backups
Next: Auto Update Statistics
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.

Thanks

--
Message posted via http://www.sqlmonster.com

 | 
Pages: 1
Prev: Backups
Next: Auto Update Statistics