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.

Technorati Tags: SQL Server Management Studio,SQL Server 2008,SQL Server 2005