From HowToGeek

The useful ones:

  • Ctrl + A Go to the beginning of the line you are currently typing on
  • Ctrl + E Go to the end of the line you are currently typing on
  • Ctrl + W Delete the word before the cursor
  • Ctrl + K Clear the line after the cursor
  • Alt + F Move cursor forward one word on the current line
  • Alt + B Move cursor backward one word on the current line

In a query pane in Aqua Data Studio… turn a query that looks like this:

into a beauty, like this:

All by pressing CTRL+B.

For the text equivalent:

select m.city, m.st, count(*)
from ___________ m
inner join ____________ z
on m.city = z.city and
m.st = z.state and
m.zip = z.zip_code WHERE
m.zip > ” AND
m.st > ” AND
m.city > ” AND
z.city is null AND
z.state is null and
z.ZIP_CODE is null
group by m.city, m.st, m.zip
HAVING count(*) <= 1 ;[/sourcecode] into: [sourcecode language='sql'] SELECT M.CITY, M.ST, COUNT(*) FROM __________ M INNER JOIN __________ Z ON M.CITY = Z.CITY AND M.ST = Z.STATE AND M.ZIP = Z.ZIP_CODE WHERE M.ZIP > ” AND
M.ST > ” AND
M.CITY > ” AND
Z.CITY IS NULL AND
Z.STATE IS NULL AND
Z.ZIP_CODE IS NULL
GROUP BY
M.CITY,
M.ST,
M.ZIP
HAVING
COUNT(*) <= 1 [/sourcecode]

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.

Follow

Get every new post delivered to your Inbox.