Equally distribute data in Secondary File within a File Group

This is a really a pain job.The Primary Data file has grown out of proportion and reached to the drive limit.Adding a new data file (secondary file.ndf) will only be used for new allocation of data or index pages. Then how to equally distribute data between the primary and secondary files , I have read […]