I think nowadays that both SD and CF are so good that it is becoming a matter of personal preference (with no right or wrong answers). the responses in this thread so far sort of show that. I use SD for JPG and video and CF for RAW. works well for me.
Nikonians®, NikoScope® and NikoniansAcademy™ are trademarks owned by Nikonians.org.
Nikon®, Nikonos® and Nikkor® are registered trademarks of Nikon Corporation.