THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Davide Mauri

A place for my thoughts and experiences the Microsoft Data Platform

SQL Server 2008 Object Explorer Details

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!

Published Saturday, September 05, 2009 1:13 PM by Davide Mauri

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



DonRWatters said:

Even better, once you have that list in the detail view, you can do a multi-select on the objects (either shift-select or ctrl-select) and delete multiple items at once.  This is great for prototyping dev work, when you're working on something and need to constantly delete new objects that are created.

September 5, 2009 12:56 PM

Buck Woody said:

September 5, 2009 8:02 PM

SteveC said:

Maybe.  I find this feature to be BULLSHIT because when I look at Views I expected to see the create date and owner as columns, but all it shows is Name and Policy Health State.  What a waste!

October 24, 2009 11:12 AM

Leave a Comment


About Davide Mauri

Davide Mauri - MCP, MCAD, MCDBA, MCT, MVP on SQL Server - has worked with SQL Server since version 6.5, and his interests cover the whole platform, from the Relational Engine to Analysis Services, from architecture definition to performance tuning. He also has a strong knowledge of XML, .NET and the Object Oriented Design principles, which allows him to have the correct vision and experience to handle development of complex business intelligence solutions. Having worked as a Microsoft Certified Teacher for many years, Davide is able to pass all his knowledge to his co-workers, allowing his team to deliver high-quality solutions. He currently works as a Mentor for SolidQ and can be found speaking in many Italian and internationals events.

This Blog


Privacy Statement