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.
Allow for Pinned Opened Tabs «
Line Number «
Word Wrap «
Prevent saving changes that require table re-creation «
Change Default Location for Saving Query Results «
Toggle the Results window On/Off «
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 ]