Linux.com reviews some Linux distros for running on older computers and includes two great LiveCDs, Damn Small Linux and Puppy Linux.
This was the first time I used DSL for any period of time, and I was impressed by what the DSL developers have managed to fit into a 50MB download.