Ok, maybe this post contains information that anyone already knows, but since I just discovered the SQL Server 2008 Object Explorer Details’ features today, maybe other people are in the same situation.
In older version of SQL Server the Object Explorer Details window was simply not useful at all since it just replicate what you can see in the Object Explorer treeview. So I never used it. This morning, doing some work for the Italian SQL Server UG, I pressed F7 instead of F8 to open the Object Explorer, and so I got the Object Explorer Details opened.
What a surprise! First of all you can search among all objects in the database:
Then, if you select and Object or an Object Class in the Object Explorer you get a lot of useful details:
For tables, as you can see, you can easly know how many rows, how much space used, in which Filegroup they belong to!
Object Explorer Details is context-sensitive, so it will display different information for different object. You can also personalize the column it shows:
That’s really useful! I wish I’ve found it before, but from now on I’ll surely use it more and more every day!