THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search
Home Blogs Downloads   Opml View as RSS news feed in XML

Davide Mauri

A place for my thoughts and experiences on SQL Server, Business Intelligence and .NET

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

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:

More info on this feature is here:

http://blogs.msdn.com/buckwoody/archive/2008/07/22/sql-server-2008-improvements-practicals-object-search.aspx

And this: http://blogs.msdn.com/buckwoody/archive/2008/09/02/selecting-columns-to-display-in-ssms.aspx

And this: http://blogs.msdn.com/buckwoody/archive/2008/09/03/the-oed-details-area.aspx

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

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 Solid Quality Mentors and can be found speaking in many Italian and internationals events.

This Blog

Syndication
©2006-2012 SQLblog.comTM
Brought to you by Adam Machanic & Peter DeBetta
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement