Wayne Sheffield has pledged to do a month worth of SSMS tips and he’s off to a good start. Here’s day 1, where he talks about creating a solution in SSMS:
Are you the type of person that has all of your custom queries in one folder, and finding the particular one that you are looking for can sometimes be a pain? Well, solutions can certainly help you. A solution consists of one or more projects, which then contain files. In SSMS, the project can contain Connections, Queries and Miscellaneous files. These various projects can be used to group your queries so that they are easily accessible.
Personally, I maintain two different solutions. One is for all the presentations that I do, each in a separate project within that solution. The other is all of my day-to-day scripts.
The first step in using a solution is to open up the Solution Explorer window. This is available from the View Menu | Solution Explorer, or by pressing the keyboard shortcut Ctrl+Alt+L.
Day two shows you how to split the screen in SSMS so you can view two sections of the same script at the same time.
Day three shows you how to create tab groups, so you can see two scripts at the same time.