They are different, the salesman must have been confused. SD is the better memory IMO because of the design. It uses bent pins and has a safer connection design.
Compact flash uses pint like a hard drive and is easy to get out of alignment and you can bend or break a pin loose from its connection. IMO the most scary thought is wo own an SLR camera with a bad CF connection because they put the CF card in upside down or at the wrong angle and a pin is bent or damaged.
Does this happen with CF memory? you bet your sweet *** it does. And those that have had it happen to them will NEVER forget it. Ive seen it happen on an older A60 powershot camera and i have actualy repaired it. After i noticed the design flaw with CF memory i no longer remove the memory and i take more caution with it.
The better design would be to reverse the design. Put the pint on the memory insted of the camera. then if there is a problem the simple solution would be to use a new memory card. They did it wrong.
I dont know wich is faster or "better" but all i know is that CF memory is a bad design. IMO go to SD memory. It is more safe.
Im alittle confused.
For the Canon SD600 camera, what are the compatible memory cards?
I was looking into the Sandisk UltraII cards, but at the store the salesperson was looking up Compact Flash but they were out of stock. Online it appears that in fact compact flash is not compatible with the sd600. I would like to get the faster acting cards, of course.
So confused!

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic