Windows Shortcut Keys

If you are using Windows, following are some handy shortcut keys with their actions to make your life bit easy.

Key Combination	Action
Windows Key + E	Opens Windows Explorer
Windows Key + L	Locks Windows
Windows Key + F	Open Search
Windows Key + R	Open Run Window
Windows Key + D	Minimise / Restore All Applications
Windows Key + Space	Peek to Desktop
Windows Key + Home	Minimise all Applications except the current Application
Shift + F10	Right Click
Windows Key + Number Keys from 1 - 9	Activate / Show Application on Taskbar.
Windows Key + Right Arrow	Switch between different Application Layouts
Windows Key + Down Arrow	Minimize an Application
Windows Key + Up Arrow	Maximize Application
Windows Key + Shift + Up Arrow	Fit Application height to screen height
Windows Key + Shift + Right / Left Arrow	Move Applications among the connected Displays when having multiple displays.
In an Application Alt + F4	Closes the Application
At Desktop Alt + F4	Brings Shutdown Window

 

I did find these in Windows 7, but have not yet tested on other versions of Windows.

 

Query Shortcuts in SQL Server 2005

There is a nice feature which I did not come accross until recently. That is Query Shortcuts. This can be very helpful when executing regularly used queries.

For example consider SELECT * statement that we use.

When ever we need to get the full record set of a table we are writing SELECT * FROM tblTable. So if we have 10 tables we need to write the same SELECT * FROM part 10 times or we may need to copy and paste that. Also mosstly, as developers we are using this statement for temporary purposes to just see what is there inside the table later we will delete the queries. In such cases the query shortcuts come in handy.


But to use them you have to set them up.
1. Open SQL Server Management Studio (SQL SMS) and go to Tools -> Options..., this will bring up the Options page.
2. In that, expand the Environment category and click on the Keyboard.
3. Now select a key combination which is easy for you to use (I selected Ctrl + 3.). Then in front of the key combination under Stored Procedure type SELECT * FROM and press ok.

Setup is done, now we'll use it.
4. Now open a new Query Window in SQL SMS. Then drag a table from the Object Explorer.
5. While the table name is selected, press the key combination (My case it is Ctrl + 3.).


See what happened?

It will run the SELECT * FROM tblTable query even though the query window is just having the table name.
Not only SELECT * FROM you can run what ever queries by using this method. But a limitation which I see is that we cannot create our own key combinations (I prefer assigning Ctrl + S or Ctrl + Space for SELECT * FROM rather than Ctrl + 3.).
I think this is useful to many developers to improve their productivity.

Nice Windows Shortcut

Do you know that you can use both sides of the title bar to close an application in Windows?
Obviously in the right side you have the Close button which you can left click to close the application.
What about the left side? Yes If you double click on the left side then also application will close.

• Windows XP and earlier

In the left corner of the title bar there will be a small icon , if you double click on this that will trigger the same action of application exit.

• Windows Vista

In vista there will be no icons, but if you click on the left corner that will still trigger the application exit.

• Office 2007

The new Office version will have a big circle on its top left corner . If you double click on or near this again the application exit will be triggered.