THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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:

clip_image001

Then, if you select and Object or an Object Class in the Object Explorer you get a lot of useful details:

clip_image001[6]

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:

clip_image001[8]

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 5, 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

Comments

 

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

(required) 
(required) 
Submit

About Davide Mauri

Director of Software Development & Cloud Infrastructure @ Sensoria, an innovative smart garments and wearable company. After more than 15 year playing with the Microsoft Data Platform, with a specific focus on High Performance databases, Business Intelligence, Data Science and Data Architectures, he's now applying all his skills to IoT, defining architectures to crunch numbers, create nice user experiences and provide meaningful insights, all leveraging Microsoft Azure cloud. MVP on Data Platform since 2006 he has a very strong background development and love both the ER model and OO principles. He is also a fan of Agile Methodology and Automation, which he tries to apply everywhere he can, to make sure that "people think, machines do".

This Blog

Syndication

Privacy Statement