Monday, March 19, 2007

Tabbed vs. MDI Queries - SQL Server 2005

I've been using Microsoft SQL Server 2005 for a few months now, and I've noticed a few differences between the SQL Server 2000 Enterprise Manager / Query Analyzer tools and the new Management Studio. I'll post some quick things I did to feel more at home in the new development environment.

Tabbed vs. MDI (Toolbar vs individual windows)

This is extremely simple, but I'm often surprised how many developers are debugging an issue but only looking at one query at a time. They often forget the exact item they are looking for. I switched to a windowed view a long time ago and found it useful to hold information in the background.


The default view in the Management Studio is to use tabs for all the queries (see snapshot). I know some developers like to see one statement at a time, but I'm usually referencing more than one query at a time.

To change the layout of the queries, chose Tools > Options from the menu. The first item under Environment gives you the option to switch between Tabbed documents and MDI (windowed).




Here is the result, all the queries are no longer in a tabbed view: