Compact Flash has always been the faster format, and will probably always will be until the transfer speeds are faster than image capture. CF cards are more robust as well. I had somebody's cheap SD card disintegrate in my hands a few months ago.

I can't even get a CF card to flex, nevermind break.
I think having a slot for each is the best of both worlds imho. It encourages people upgrading, it allows for backup, and with a SD slot cards are easily available.
However if I was a Pro, and I had a Pro camera, I would want two CF slots. I would want the most reliable and quickest cards/slots available.
When I got my D300S I started writing Jpegs to the SD slot, because I could,

even though I always shoot RAW files. I'd had the odd RAW file corrupt during continuous bursts (though not with the Sandisk cards I use now

) They never got looked at, and were not even transferred. Then I was taking lots of pics quickly at a sporting event and it suddenly occurred to me that writing the info, even if they are Jpegs to the SD card as well could possibly slow the camera down at a crucial point. Two data streams taxing the processing power and buffers etc, (it may not make a difference but I can see how it could) so I use the SD slot as an overflow now. I hardly ever fill a card to use it, bit it is there if I ever forget extra cards.
As files get larger, and HD video starts to be more prevalent, card speed becomes a factor to consider, and the CF cards are the fastest you can get.
I get the feeling that the fastest CF cards seem to be waiting for the cameras to catch them up, but the fastest SD cards seem to be designed to be just fast enough. For now anyway.
