Experience, Knowledge, Creativity

  • Increase font size
  • Default font size
  • Decrease font size
Home SQL SQL Server Management Studio Tricks

SQL Server Management Studio Tricks

E-mail Print PDF

This post was inspired by Quick poll : what is your favorite Management Studio tip or trick? by Aaron Bertrand on

My favorite SMSS (2005 for me) tricks include:

  • CTRL-Tab for switching between windows.
  • CTRL-R for showing and hiding the results pane.
  • Include column headers when copying or saving the results options under Tools | Options | Query Results | SQL Server | Results to Grid.
  • Highlight any table or view name in T-SQL and hit Alt+F1 for sp_help and a list of its fields. (Suggested by dan from the above mentioned post.)

More tips here: DAT315 – Session Review for SSMS Tips & Tricks Session by Bill Ramos.



Subscribe by e-mail:

Site Search

Google Ads