Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Nakul Vachhrajani is a Technical Specialist & Systems development professional with iGATE. He holds a MCTS (SQL Server 2008: Implementation & Maintenance)
Browse by Tags · View All
#SQLServer 305
SQL Server 304
Administration 252
DBA 241
T-SQL 234
#TSQL 232
Development 226
Tips 216
Guidance 148
Best Practices 119

Archive · View All
April 2011 14
March 2012 11
December 2011 11
March 2011 11
December 2012 10
October 2011 10
January 2011 10
September 2013 9
January 2013 9
November 2012 9

#0197-SQL Server-SSMS-Disconnect all queries feature

Sep 20 2012 12:00AM by Nakul Vachhrajani   

Have you ever been in a situation wherein you have been working furiously on your SQL Server Management Studio (SSMS) on multiple query windows and you need to rush out to a meeting? As you know, each query editor window within the SSMS opens a new connection to the SQL Server. Open connections mean more resources being consumed at the server. Hence, when going into a meeting or lunch, one may not want to keep these connections open. I don't.

So, what do I do in such cases?

The answer is simple: I use the “Disconnect all queries” feature available in the SSMS query editor right-click context menu. Here’s a short demo.

As you can see in the screen-shot below, I have 4 queries open – each connected to a different SQL server instance (to cycle through the open queries, simply use the Ctrl+TAB keyboard shortcut).

image

Now, to disconnect all queries from the corresponding SQL Server instances in one go, right-click in the query editor window, go to Connections->Disconnect all queries.

image

Upon clicking “Disconnect all Queries”, notice that the tabbed document spaces for all queries are now reading “not connected”.

image

I personally don’t like to reopen the SSMS often – it’s launched once in the morning, and the only time I close it is when I shut down my laptop in the evening.  Having a “disconnect all queries” is a cool little feature that comes in very handy.

Hope you like it as much as I do! Do you know of any cool features within SSMS? Do let me know!

Until we meet next time,

Be courteous. Drive responsibly.

Tags: #SQLServer, SQL Server, Tips, Administration, Development, DBA, Tools and Utilities, HowTo, Tips, SSMS


Nakul Vachhrajani
4 · 36% · 11635
11
 
0
Lifesaver
 
 
 
0
Incorrect



Submit

1  Comments  

  • Very Useful. You can also do this using following main menu.

    Query --> Connection --> Disconnect All Queries

    The keyboard shortcut is Alt+Q, C, A

    commented on Oct 3 2012 2:26PM
    Madhu Gorthi
    2076 · 0% · 7

Your Comment


Sign Up or Login to post a comment.

"#0197-SQL Server-SSMS-Disconnect all queries feature" rated 5 out of 5 by 11 readers
#0197-SQL Server-SSMS-Disconnect all queries feature , 5.0 out of 5 based on 11 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]