I don’t know why I have this habit, but typically I write most of my queries in lowercase. All lowercase. Once I’m ready to publish them or have them reviewed, I’ll convert everything applicable (some parameters don’t need to be made uppercase) to uppercase.
CTRL+SHIFT+U converts your text selection to uppercase. CTRL+SHIFT+L converts your text selection to lowercase.
[Via] From Windows Explorer, in Details View, to auto-expand to the longest column just press CTRL+NumPadPlus.
This one is my new favorite.
Just enter one of the files (filename.msc) into the Run Program Dialog. Performance Monitor doesn’t require a .msc extension. The one I use the most is services.msc.
- Certificates – certmgr.msc
- Indexing Service – ciadv.msc
- Computer Management – compmgmt.msc
- Device Manager – devmgmt.msc
- Disk Defragmenter – dfrg.msc
- Disk Management – diskmgmt.msc
- Event Viewer – eventvwr.msc
- Shared Folders – fsmgmt.msc
- Group Policy – gpedit.msc
- Local Users and Groups – lusrmgr.msc
- Removable Storage – ntmsmgr.msc
- Removable Storage Operator Requests – ntmsoprq.msc
- Performance – perfmon.msc
- Resultant Set of Policy – rsop.msc
- Local Security Settings – secpol.msc
- Services – services.msc
- Windows Management Infrastructure (WMI) – wmimgmt.msc
- Component Services – comexp.msc
After you’ve parsed your query, in SQL Server, just press F5 and the query will be executed.
Instead of going up to the check mark to parse your query for syntactic goodness, just press CTRL+F5.
This one is a little niche, but it’s saved me loads of time.
At work I use an IBM Thinkpad (T42p, to be specific) – and when I undock to go home, sometimes my funciton key is locked.
To unlock, press Shift+ScrollLock
When you’re using Remote Desktop to administer another computer, you may occaisionally need to view running processes. First, you try CTRL+ALT+DEL. This brings up your local machine’s CTRL+ALT+DEL screen, but in order to bring up the remote computer’s CTRL+ALT+DEL screen you must press CTRL+ALT+END.
This one has been bugging me for a while.
If you’re using Remote Desktop from an MMC snap in your Alt-Tabs aren’t effective on the machine you’re remotely accessing.
Just use Alt+PageUp to scroll through your open programs from left to right and Alt+PageDown to scroll through your open programs from right to left.