I have a question related to space on drives and size of mdf files.
I have very little space left on one of my drives which holds some of my mdf files only (log files on another drive)
Rather then shrinking the mdf to avoid fragmentation - I was wondering what options are best to approach.
Currently the database has only one filegroup for the data file.
Would it help to create another data file for the database on another drive? would this automatically start loading the data to this filegroup, and once the two mdf (data) files get to the same size, would they start sharing the loading?