Friday, April 05, 2013

Type an Ascii character in Windows, Alt Codes, Useful Links

If you're like me, you have a fairly limitted selection of special characters that you want to insert into your documents or messages on a regular basis.

There are several ways to do this, as outlined here:

I've taken to using alt-codes for the ones I use most frequently.  Memorizing a few of these can be a big time-saver.  Good list here:

Some of the ones I find most useful:
ALT-3        ♥
ALT- 14     ♫
ALT - 126   ~
ALT - 236   ∞
ALT - 241   ±
ALT - 242   ≥
ALT - 243   ≤
ALT - 0162 ¢  (Not in the linked page - look here:
ALT - 0169 © (Not in the linked page - look here:
ALT - 0174 ® (Not in the linked page - look here:

Those who write Spanish will find these useful:
¿  ALT-168
¡  ALT-173

There are also some accented letters you can check into, found here:

Monday, April 01, 2013

Finding large files and directories on Windows

One of the most useful tools I've found for troubleshooting full drive issues is WinDirStat.

Since it seems that it's being bundled with all sorts of yuck-ware by all sorts of people, I thought I'd post the sourceforge link to the software.

It gives a nice sort of heat map of where your large files and directories reside.  Very good tool, and much faster than the jdiskreport that I previously recommended from JGoodies, although I will say that is also a very worthy tool.  We have some systems that don't have java installed, though, and this tool is faster and doesn't have the java requirement.

Minimally Logged Operations in SQL Server

I'm posting this mostly so I can find it later :) The following article has a great table that defines when operations will be minimall...