Your Site
Web site promotion
Is your site looking a little weathered, dated? Why not consider updating it!!!

Training
Training

E-Commerce
e-commerce

Web Site Packages
  • Database Solutions
  • Shopping carts
  • Hosting

Project Management
Project Management
  • Database Solutions
  • Shopping carts
  • Hosting

Hardware Setup
Hardware

SQL Tips and Tricks

"Productivity aids"
Query Analyzer is a great tool to have and here are a list of all the shortcut keys you can use to speed up your keyboard capabilities to use Query Analyzer.
Bookmarks: Clear all bookmarks. CTRL-SHIFT-F2
Insert or remove a bookmark(toggle). CTRL+F2
Move to next bookmark. F2
Move to previous bookmark. SHIFT+F2
Connections: Connect. CTRL+O
Disconnect. CTRL+F4
Disconnect and close child window. ALT+F4
Editing: Clear the active Editor pane. CTRL+SHIFT+DEL
Comment out code. CTRL+SHIFT+C
Copy. CTRL+INSERT. OR CTRL+C
Cut. SHIFT+DEL. OR CTRL+X
Decrease indent. SHIFT+TAB
Delete through the end of a line in the Editor pane. CTRL+DEL
Find. CTRL+F
Go to a line number. CTRL+G
Increase indent. TAB
Make selection lowercase. CTRL+SHIFT+L
Make selection uppercase. CTRL+SHIFT+U
Paste. SHIFT+INSERT. OR CTRL+V
Remove comments. CTRL+SHIFT+R
Repeat last search or find next. F3
Replace. CTRL+H
Select all. CTRL+A
Undo. CTRL+Z
Navigation: Switch between query and result panes. F6
Switch panes. Shift+F6
Window Selector. CTRL+W
Results: Display results in grid format. CTRL+D
Display results in text format. CTRL+T
Move the splitter. CTRL+B
Save results to file. CTRL+SHIFT+F
Show Results pane (toggle). CTRL+R
Templates: Insert a template. CTRL+SHIFT+INSERT
Replace template parameters. CTRL+SHIFT+M
Tuning: Display estimated execution plan. CTRL+L
Display execution plan (toggle ON/OFF). CTRL+K
Index Tuning Wizard. CTRL+I
Show client statistics CTRL+SHIFT+S
Show server trace. CTRL+SHIFT+T
Help Help for SQL Query Analyzer. F1
Help for the selected Transact-SQL statement. SHIFT+F1
  Database object information. ALT+F1
Execute a query. CTRL+E OR F5
New Query window. CTRL+N
Object Browser (show/hide). F8
Object Search. F4
Parse the query and check syntax. CTRL+F5
Print. CTRL+P
Save. CTRL+S
Use database. CTRL+U
Cancel a query. ALT+BREAK