One of the good things about working in technology is that you always will discover new things. The other day I created a blog post: Listing all your SQL Server databases ordered by size. Buck Woody replied to me on twitter that this is also built into SSMS. He tweeted the following link: Selecting Columns to Display in SSMS
I decided to check it out. I knew already about the details pane, I use it all the time if I need to script more than one object. I blogged about it here as well: Scripting all jobs on SQL Server 2005⁄2008 into one file
What I did not know is that you can change the columns that are shown. Click on he databases folder in SSMS and press F7, this will bring up the details pane, it looks somewhat like the image below
Right click on any of the columns and you will see the following menu
Now I don’t care for some of the things that are shown by default, I unchecked some of them and checked others. Here is what it looks like now, much better for what I need to see at a glance
You can sort the results by clicking on a column, click it again and it is sorted in the reversed order
Did you know that if you do CTRL + A, CTRL + C, it copies it as TAB delimited, just paste it into Excel
What about you, what ‘new’ things have you discovered in SSMS?