title: Is having multiple data/log files a good thing even on the same LUN?
body: <p>I have read that it is a good idea to have one file per CPU/CPU Core so that SQL can more efficiently stream data to and from the disks.  Ok, I can see the benefit if they are on different spindles, but what if I only have one spindle (4 drives in Raid 10) for my data files (.mdf and .ndf), will I still benefit from splitting the data files (from just the .mdf file to a .mdf and several .ndf files)? Same goes for the log file, although I see no benefit to it as the data has to be written serially and you're limited by the spindle's sequential write speed...</p>
  
  <p>FYI, this is in regards to SQL Server 2005/2008...</p>
  
  <p>Thanks.</p>