SSMS Shortcut Keys

ALT+X to execute batches, but I am trying to move to CTRL+E

However CTRL+K, CTRL+U or CTRL+K, CTRL+C for commenting/uncommenting are way up there for me as well.

If you go to Tools/Options/Environment/Keyboard you can associate your own stored procedures to shortcut combinations. For example if you often need to select the top five rows of a table, add this to master and associate a keyboard combination in the options with the stored procedure. You'll have to open a new query window for the changes to take effect. The cool thing here is that any selected text is passed in as a parameter to the associated stored procedure.

CREATE PROCEDURE sp_select_top5 @table varchar(8000) 
AS BEGIN 
 declare @dynamicSQL varchar(8000) 
 set @dynamicSQL = 'select top 5 * from ' + @table 
 exec(@dynamicSQL);  
END

Save Save Save (even if there's auto-save ON, please save)

CONTROL S

My favorite is SHIFT + ALT + Arrows. Its not Shortcut, but I liked it a lot !!!

Ctrl + N - New Query