Praveen Barath replied to my Query Analyzer Shortcuts post, explaining why SSMS in SQL Server 2005 feels slower and why its features are worth learning.
Templates and Snippets in SSMS
Templates and snippets in SSMS turn repeated SQL patterns into editable starting points while keeping environment assumptions visible.
SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example
Open SSMS from command prompt with the sqlwb command. I show its syntax and the switches I use, like -E and -nosplash, to start Management Studio.
SQL SERVER – Query Analyzer Short Cut to display the text of Stored Procedure
A quick Query Analyzer shortcut: map sp_helptext to a key, select any SP name and display the text of Stored Procedure right in the result window.
SQL SERVER – Query Analyzer Shortcuts
A handy table of Query Analyzer Shortcuts with each key combination and what it does, like CTRL+E to execute a query, plus a PDF copy you can download.