Is your SQL Server using directly attached storage or is it using a SAN? If you use a SAN then any separate "drives" your server sees may just be logical drives carved out of the same physical array of disks, so it doesn't really matter then. I suppose to answer your other questions, it depends on the RAID level the disk array is setup with, and what you mean by "it blows up" as to what the effects will be.