Independent multiple query window in multiple screen (monitor) in SQL Server 2012

Independent multiple query window in multiple screen (monitor) in SQL Server 2012

 

I love working with dual monitor and I really appreciate one GUI feature in SQL Server 2012 which support query window across multiple monitor screens. Many time I have situation that I have on SP which return some records and new version of same SP which again return some records and I have to compare both record set, I used to do it by copying it to excel but now in SQL Server 2012, I can compare it right withing two query window in dual monitor. SQL Server 2012 management studio is build up based on Visual Studio 2010 which also support same feature.

 

It is really very easy to use this functionality. Just double click on query window table and you can see that window comes out of the boundary of SSMS so that you can drag it to anywhere and make the size of your choice. See the following screen capture to see where exactly we need to double click.

1SSMSQueryTab

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Once window comes out of the SSMS, drag the window anywhere you want, I drag it to another monitor and it looks like following screen capture.

2DualScreen

 

Now, I can easily compare the record set from both the query.

 

If you like this article, do like “Extreme-Advice” page in Facebook.

Reference: Ritesh Shah

http://Extreme-Advice.com

http://www.sqlhub.com

Note: Microsoft Books online is a default reference of all articles.