SQL File Group Notes

  When you add a new file to a file group SQL Server doesn’t rebalance the data across the database files, you have to do this manually by rebuilding all the indexes, but new rows would be written to the new file.


I also wanted to know about Database Partitioning;