I usually run Query Analyzer Sql Server Management Studio with my query results being displayed as text. But every now and then I really need them to show up in a grid...usually for copying and pasting. Whenever this happens it's always a process of me sitting there clicking through menus until I remember that you can change that setting under Tools -> Options -> Query Results -> Default destination for result
What a pain in the ass.
Today I discovered the keyboard shortcut for making this change and committed it to memory (AKA the yellow sticky note on my monitor). Here they are for you, and for me when I forget sometime in the near future.
CTRL+D: Results in a grid
CTRL+T: Results as text
Another one that Mark was asking me about the other day... how to insert a NULL into a column when you have the table open in Management Studio.
CTRL+0 (zero)
If you are dead set on never touching the mouse, here is the definitive list from SQL Server 2005 Books Online:
http://technet.microsoft.com/en-us/library/ms174205.aspx
They don't seem to have that insert NULL shortcut listed there though. I wonder if any others are missing?