THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Aaron Bertrand

An annoyance with Management Studio

I am probably speaking out of turn here (it is not Saturday, after all), but I was really annoyed with this SSMS grid problem today, and had to get it off my chest.  I was waiting for a log restore to complete, and periodically running sp_who2 to determine IO completed thus far.  I could have written a query against the DMVs but might have been hit with the same issue.  Essentially, the problem is that the grid alignment in the results pane of SSMS is horrible and often guesses wrong.  What this yields is a lot of data that is obscured by ellipses because SSMS decided that it would make a column 60px wide when 65px would have shown all of the data (and plenty of cases where it makes a column 200px wide when 60px would have been enough).  In this specific case, of course, it was particularly annoying: it consistently obscured only one value in the entire grid: the one I was interested in!

So what did I have to do?  Every time I ran the query to check on the result, I had to drag or double-click on the column header boundary in order to show the whole value.  This is the epitome of annoying.

SSMS can be SO annoying 

Now I complained about grid alignment last summer, and due to my frustration today, will likely include a reference to this item in this week's Connect digest.  But in case you want a sneak preview:

#356926 : SSMS : Grid alignment, column width seems arbitrary


Published Tuesday, June 23, 2009 1:55 PM by AaronBertrand
Filed under: ,

Attachment(s): SSMS_Annoyance.PNG

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

 

Adam Machanic said:

User error! Your mistake was running sp_who2 when there are other options that don't have this problem <g>

June 23, 2009 1:20 PM
 

AaronBertrand said:

Well, this system doesn't yet have your solution in place.  :-)

In any case, the same thing could happen with it; SSMS is blindly determining column widths based on some initial subset of the data.  Boo!

And please don't suggest switching to Results to Text.  I would complain a lot more about that than the grids.  :-)

June 23, 2009 1:27 PM
 

Linchi Shea said:

I don't know. You complain too much, Aaron :-) That seems to be a rather minor annoyance compared to such issues as the completely unusable query window tabs.

June 23, 2009 2:05 PM
 

RowlandG said:

Where's TOAD when you need it ;)

June 23, 2009 3:01 PM
 

Linchi Shea said:

Aaron;

I posted my previous comment before actually finishing it. Not to diminish it, I meant to say that there probably would be a long list of items before this one in terms of the degree of annoyance.

June 23, 2009 3:14 PM
 

Aaron Bertrand said:

It was slim pickings this week. One item I thought deserved some attention was one that was filed a year

June 27, 2009 11:25 AM
 

RayG said:

You could switch to "results to text" just for the purpose of the query.  Avoids the problem, but yes, annoying.

August 25, 2009 6:52 AM
 

AaronBertrand said:

RayG, in many cases if I switch to results to text, some of the data I was looking for was actually off the screen to the right, so still required manual intervention to be on the screen.  I like the grid because it makes data a little more compact, it just makes funny decisions to do so in weird places.  I also like the grid because it turns multi-row data into single-row.  Ever try results to text when any of your columns have carriage returns?

Results to text has its place (e.g. sp_helptext), but when you have may columns and you really want to look at the data in a tabular format, it's not the way for me.

August 25, 2009 7:04 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About AaronBertrand

...about me...

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement