SQL Server Management Studio Tips – Part 4

This is the fourth in a series of posts highlighting Scott Cate’s video series of Visual Studio tricks over the last few months from Sara Ford’s blog.

As I mentioned in Part 1, many of the commands are documented in the SQL Server 2008 help topic – SQL Server Management Studio Keyboard Shortcuts.

Blog Post	Comments
#57 [Ctrl]+[J] invokes statement completion	This works best when using aliases.
#59 Resize the Statement Completion Window	A handy way to see more items where vertical size is persisted.
#61 Presenters Must Read .. Increase the Editor Tooltip Font Size	This is something that I already have in my demo environment. It’s useful for people with old eyes as well.
#62 Display parameter info for a function	Using [CTRL]+[SHIFT]+[SPACE] is very handy if you missed the parameter info the first time.
#64 Keyboard Shortcut to Display Quick Info Tooltip	In SSMS, the command is a little different. You need to use [CTRL]+[K], [CTRL]+[I]
#65 Edit.WordComplete via Intellisense	This is handy typing in column names without having to display the drop down list. *[CTRL]+[Space] or [ALT]+[RIGHT]*
#66 Using Quick find in the Current Document	Calls out how you can also dock the Find tool window.
#67 Search in hidden text in the editor	Something to remember if you get in the habit of collapsing statements.

That’s all of Scott’s great tips that also apply to SSMS.

Comments

Anonymous
April 10, 2009
PingBack from http://asp-net-hosting.simplynetdev.com/sql-server-management-studio-tips-%e2%80%93-part-4/