Previous
Left Arrow
Creating Indexes that include all columns that will display to your page in SQL Server.
Current Code Entry
Go Back To Code List
[SQL Server]
  • Information on how to use SSMS more efficiently

    Article Entry Date: March 9,2026 @ 04:12:37 / Last Updated On: March 9,2026 @ 04:12:37
Working in SSMS (SQL Server Management Studio) can be daunting if you don't know your way around the interface.
In this Article, you will find all the helpful ways I work in SSMS in my daily productive environment.

  1. Allow for Pinned Opened Tabs«
  2. Line Number«
  3. Word Wrap«
  4. Prevent saving changes that require table re-creation«
  5. Change Default Location for Saving Query Results«
  6. Toggle the Results window On/Off«
  7. Comment and Uncomment out code«

Allow for Pinned Opened Tabs
Got to
[Options] | [Environment] | [Tabs and Windows]
Check this box.
[x]Show pinned tabs in a separate row
(This will allow you to Pin the most used window to the top of the Stack.
All other windows will be below the Pinned Tags.

Line Number
Got to
[Options] | [Text Editor] | [All Languages] | [General]
Check this box.
[x] [Line Numbers]

Word Wrap
[Options] | [Text Editor] | [All Languages] | [General]
Check this box.
[x] [Word Wrap]

Prevent saving changes that require table re-creation
[Options] | [Designers]
Uncheck this box.
[ ] [Prevent saving changes that require table re-creation (Uncheck)]

Change Default Location for Saving Query Results
[Options] | [Query Results]
Default location for saving query results: (Mine is stored here, and this location is backed up.)
[G:\SQL Server Data\Query Results]

Toggle the Results window On/Off
When working on your Query, you may not want the Results window open all the time.
To toggle off or on, click [Ctrl]+[R]

Comment and Uncomment out code
Sometimes you want to comment out sections of code, or maybe you wrote up information about what a certain thing does.
To comment out.
Click [Ctrl]+[K] then [Ctrl]+[C]
To Uncomment
Click [Ctrl]+[K] then [Ctrl]+[U]