I just installed the Allocation Information add-in for SQL Server Management Studio.  It’s very cool having this tool integrated into SSMS. It is a free add-in published on CodePlex. Take a look, it does worth the download in my opinion.

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2008/08/18/get-sql-server-allocation-info-inside-ssms.aspx