SSMS Configuration Tips

SSMS Configuration Tips

Recently my install of Management Studio decided to reset itself back to the defaults. After a bit of hunting around for the blog posts that listed some great configurations, I decided to make note of my preferred settings here, for future reference.

Open a new query page at Startup

Tools | Options |  Environment | At startup: – Select Open Object Explorer and new query

Create DMV shortcuts

Tools | Options |  Environment | Keyboard | Query shortcuts:

I add “select * from sys.dm_exec_sessions” and “select * from sys.dm_exec_requests” to Ctrl keys.

Display line numbers

Tools | Options |  Text Editor | All Languages | Display | Line Numbers

Know where you are through colour coding

Save yourself some grief by making group connections an obvious colour (bright red!) so that you don’t execute some script on a bunch of servers accidentally.

Tools | Options |  Text Editor | Editor Tab and Status Bar | Status Bar Layout and Colours | Group Connections

I usually move the status bar location to Top to make the colour even more obvious.

I also find Mladen Prajdić’s SSMS Tools Pack to be invaluable for colour-coding windows of specific servers.

More readable tabs

I find the tabbing in SSMS to be frustrating because it’s so hard to see what’s on a specific tab.

Tools | Options |  Text Editor | Editor Tab and Status Bar | Tab Text – Set all to false except Include file name.

Reduce wait times

Tools | Options | SQL Server Object Explorer | Table and View Options | Value for Select/Edit Top <n> Rows

I rarely need to see 1000 rows when I do a select on a table. It’s usually just a shortcut to the query text so I can start modifying it for other purposes.

Avoid some costly mistakes

Set up a Query Template (via SSMS Tools Pack) such as “BEGIN TRAN/ROLLBACK”.

Want more than you see here? Check out Kimberly Tripp’s Favorite SSMS Options – and some gotchas and Brent Ozar’s Fixing SQL Server Management Studio’s Tab Text. Have a favourite? Let me know in the comments.

These are simply my preferences, I’m not recommending them.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.