title: Performance Impact of Empty file by migrating the data to other files in the same filegroup
body: <p>We have a database currently sitting on 15000 RPM drives that is simply a logging database and we want to move it to 10000 RPM drives. While we can easily detach the database, move the files and reattach, that would cause a minor outage that we're trying to avoid.</p>
  
  <p>So we're considering using <code>DBCC ShrinkFile with EMPTYFILE</code>. We'll create a data and a transaction file on the 10000 RPM drive slightly larger than the existing files on the 15000 RPM drive and then execute the <code>DBCC ShrinkFile with EMPTYFILE</code> to migrate the data.</p>
  
  <p>What kind of impact will that have?</p>