Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Starting Query Analyzer Expand / Collapse
Author
Message
Posted Thursday, September 8, 2005 9:40 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 12:13 PM
Points: 33, Visits: 395
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/yShlafman/startingqueryanalyzer.asp
Post #218244
Posted Wednesday, October 12, 2005 1:51 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 5:59 AM
Points: 94, Visits: 294

Yakov,

Like you said, there are several ways to get in to QA. One other method of starting QA that you didn't mention, and the one I tend to use the most, is to start it from within Enterprise Manager. By using the appropriate shortcut keys for the Enterprise Manager "Tools" and then "SQL Query Analyzer" menu options you can fire off QA with a combination of "Alt+T", "Q" keystrokes. This method has the added feature of using whatever credentials you are currently running EM with.

Another method you could use would be to assign a "Shortcut Key" combination to the QA entry in your Program Files - this can be done by right-clicking the QA entry and looking under its properties. I don't actually have a shortcut key combination set up for QA but I have set up several others which save me time on a regular basis (e.g. Ctrl+Alt+W to load Word, Ctrl+Alt+X to load Excel, Ctrl+Alt+N to load Notepad, Ctrl+Alt+E to load Enterprise Manager...)

I know it's personal preference but if I can ever find a way of doing things without a mouse, or any other pointing device, I will.

Mark




Post #228199
Posted Wednesday, October 12, 2005 3:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 14, 2008 3:43 AM
Points: 37, Visits: 12

Of course, there are other, MUCH simpler ways of adding shortcuts to your Quick Launch bar, and of opening the Run dialogue.

First, shortcuts. Click on Start, and navigate to the program you want to add to Quick Launch (QL). Instead of the 6 steps to 'Send it to your desktop', then drag it from your desktop to the QL bar, just RIGHT click and drag straight from the Programs menu to the QL bar. When you relaes the mouse, select 'Copy To' rather than the default 'Move To' otherwise it will dissapear from the Programs menu.

To launch 'Run', just use the 'WindowsKey + R' shortcut - much easier than adding another shortcut to the QL bar (WindowsKey + E also opens Explorer a great deal faster than using any menus).

The command line switches were useful. Unless you try each Windows executable from a command line, it is not always obvious which support switches and which don't. Query Analyser supports several more of them too. Open the Run dialogue, and enter isqlw /? to get a full list.

Regards

Adam

Post #228210
Posted Wednesday, October 12, 2005 4:47 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:01 AM
Points: 1,070, Visits: 906

After all these years as a dba, finally someone has shown me how to become a power user!

 

Fantastic, thank you all!




Post #228228
Posted Wednesday, October 12, 2005 5:04 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Saturday, July 12, 2014 6:44 AM
Points: 441, Visits: 1,799

This is what my start menu looks like

Start Menu

 

Windows Key followed by 1 Opens QA, Windows Followed by 2 EM.  I also have short cuts assigned on the Shortcuts, so I can press Ctrl + Alt + 1 for QA etc.

 

 




http://glossopian.co.uk/
"I don't know what I don't know."
Post #228234
Posted Wednesday, October 12, 2005 5:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 4:59 PM
Points: 2,693, Visits: 1,204

One of my most used command-line switches is -C. This loads a previously saved configuration file. Comes in very handy when you have a couple of people working on a server via remote desktop and they each have their own favourite fonts

Also, one little know tip for the Quick Launch menu, re-size the toolbar so that only the double arrows are visible, if you click the arrows a popup menu appears and you can select your shortcut from the menu. Below is a screenshot of how this looks on my home computer with the toolbar title visible.

You can also create your own toolbars full of whatever shortcuts you need. Just choose "New Toolbar..." from the Toolbars menu. I have 4 on my work computer, "Quick Launch", "SQL Admin", "Development" and "Remote Desktops".



Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #228239
Posted Wednesday, October 12, 2005 7:08 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 7, 2013 11:44 AM
Points: 51, Visits: 40
Being able to run Query Analyzer from the command line was worth the price of admission, that is the time I took to read the article. I will use that alot!


Post #228274
Posted Wednesday, October 12, 2005 7:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:58 PM
Points: 92, Visits: 170

Another quick way would be to assign a combination of keys to the shortcut and then you could open it with ctrl-alt-q for example.

You can do this by right clicking the shortcut, properties, short cut key.

I use this technique a lot because I have a bad hand and moving from keyboard to mouse is difficult so I use keyboard shortcuts with keys I can press with the left hand.

 

Post #228294
Posted Wednesday, October 12, 2005 8:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 14, 2008 3:43 AM
Points: 37, Visits: 12

Philcart

Also, one little know tip for the Quick Launch menu, re-size the toolbar so that only the double arrows are visible, if you click the arrows a popup menu appears and you can select your shortcut from the menu. Below is a screenshot of how this looks on my home computer with the toolbar title visible.

That would certainly save task bar space, especially if you have other tool bars. I can't get my QuickLaunch bar that small though - the smallest it will go is 3 icons wide. Is there some trick to make it smaller?

You can also create your own toolbars full of whatever shortcuts you need. Just choose "New Toolbar..." from the Toolbars menu. I have 4 on my work computer, "Quick Launch", "SQL Admin", "Development" and "Remote Desktops".

This is an excellent idea, especially the Remote desktop one (I often have 4 or 5 desktops open at any one time). You can then create a seperate .rdp file for each shortcut, to save the settings for that remote server, including the password (if you want to save it) for instananeous log in. Thanks!

Incidentaly, as this thread started by discussing command line switches, there is a really good one for TerminalServer/Remote Desktops. If you add the switch /console to the command in the shortcut (or start RD by entering mstsc /console into the Run dialogue) then you get the actual deskop of the server, not a virtual console. If someone is using the console at the time, they get logged off, unless you are using the same account, in which case you get to takeover their session (they are still locked out though). This is the only mode remote sessions to XP machines work, and is an optional switch on Win2K3 remote desktops. It doesn't work when connecting to a Win2K machine though

Regards

Adam

Post #228318
Posted Wednesday, October 12, 2005 8:27 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, November 6, 2007 11:10 AM
Points: 52, Visits: 3
If you have a particular database, or group of databases, you use regularly you can modify the properties of your shortcut in the quick launch bar (or your desktop, for that matter) by doing the following.
1. Right-click on the Query Analyzer Shortcut, select "Properties".
2. Modify the Target to be something like this ""C:\Program Files\Microsoft SQL Server\80\Tools\Binn\isqlw.exe" -SYourServerName -dYourDBName -E".

Naturally, if you are using a SQL Login, you'll need to make a few adjustments, but hopefully y'all get the idea. It sure saves time! One click and you are in Query Analyzer using the Server and DB you need. I several shortcuts in my quick launch bar, one for each server/database I use repeatedly throughout the day.



Post #228319
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse