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»»

SSMS Tricks Expand / Collapse
Author
Message
Posted Sunday, December 23, 2007 12:16 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:16 PM
Points: 31,018, Visits: 15,456
Comments posted to this topic are about the item SSMS Tricks






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #436051
Posted Monday, December 24, 2007 7:38 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 4, 2011 7:20 AM
Points: 977, Visits: 1,499
That is all pretty good stuff, and most, I didn't know.

I still use SQL Query Analyzer as my primary editing tool, and will continue to do so. I have even installed it to servers that have never seen SQL Server 2000. It's main limitation is it's inability to "Edit" (from the menu) an existing object, and that's not a real show stopper.

The functionality of the SSMS SQL editor has gone the wrong way in my opinion.

Annoyance #1: Double-click on a quoted or bracketed word, and the selection includes the quotes or brackets.

Annoyance #2: Ctrl-Left, Ctrl-Right movements don't jump a block of special characters (--), but hops them one by one.

If this is the "Old dog /New trick' thing, then so be it, but it's a great editor, and 'Start>>Run>>isqlw' is pretty firmly embedded in my memory. (:

Tom Garth



Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #436152
Posted Monday, December 24, 2007 8:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 4, 2010 9:46 AM
Points: 184, Visits: 43
Good article, but there is one thing. You seem to be implying that using -nosplash makes SSMS start faster. If you actually time it (I did before I posted this) it starts in the same amount of time regardless of the setting (3 seconds on my box). If a splash screen is implemented correctly, it never slows down the start up of the application, it just gives the user something to look at when they start up the app so they have immediate feedback and don't try starting the app again because they think "did I start that?"

OK, with that said, I suppose if you have some killer machine and your SSMS starts almost instantly with –nosplash and slower without using –nosplash that may mean that Microsoft put in a minimum time to show the splash screen so the splash would not flash.

Thanks,
Jim
Post #436158
Posted Monday, December 24, 2007 9:40 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:16 PM
Points: 31,018, Visits: 15,456
I definitely agree with you on SSMS. I tend to use QA unless I need to see an existing object. I like quick, lightweight stuff.

Jim,

you are correct and if I implied that, I did not mean to. It doesn't start quicker, just doesn't show the splash screen.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #436175
Posted Monday, December 24, 2007 12:14 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, May 12, 2014 12:57 PM
Points: 2,281, Visits: 4,225
FYI: SQL Server 2008 SSMS starts much faster than 2005. An initial open takes about 9 seconds versus about 45 seconds for SSMS 2005 and a second open about 2 seconds. Computer is 1.6Ghz with 1GB of memory.


SQL = Scarcely Qualifies as a Language
Post #436204
Posted Wednesday, December 26, 2007 8:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 9, 2008 9:25 AM
Points: 23, Visits: 62
Good article. Reminds me of a gripe I have about MS, though. In Enterprise Manager, using external tools, you could open explorer on the server where you had an open session of SQL Server - with Command = C:\\Windows\\explorer.exe (location of explorer on your desktop) & Parameter = "\\[SRV]\C$". Very handy, also works for server manager & event viewer, with the \\[SRV] parameter. Doesn't work any more with External Tools using Management Studio. BOL says it should work, but it doesn't.
Post #436344
Posted Wednesday, December 26, 2007 10:33 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 16, 2008 3:33 PM
Points: 327, Visits: 220
Excellent article. All simple but effective tips.

Warm Regards,
Neel aka Vijay.
Post #436549
Posted Thursday, December 27, 2007 5:26 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:47 PM
Points: 35,215, Visits: 31,667
!! DIR C:\Temp


Not real sure I'm happy about THAT working because the following also works...

!! DEL C:\Temp\some file name

Great article of tips, Steve... thanks.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #436618
Posted Friday, December 28, 2007 7:18 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 11, 2009 8:20 AM
Points: 269, Visits: 1,093
Steve Jones - Editor (12/24/2007)
I definitely agree with you on SSMS. I tend to use QA unless I need to see an existing object. I like quick, lightweight stuff.

Steve,

Great article - a lot of good tips. What are the advantages to using QA over SSMS? Are there any other limitations besides the one you mentioned? In my role, I may not use either of them as extensively to see a difference.



Ian.

"If you are going through hell, keep going."
-- Winston Churchill
Post #437037
Posted Friday, December 28, 2007 9:07 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:16 PM
Points: 31,018, Visits: 15,456
The only advantage for QA that I've seen is that it's quick and starts immediately. I don't need to spend time waiting on SSMS to start up, eat system resources, and shut down to get a query done. QA can start up and have me enter a password in 5 sec.

Other than running a quick query, QA doesn't allow me to work with SS2K5 servers (see objects, edit them ,etc.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #437094
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse