Hello all-
We were experiencing some very long load times for a fairly large table (21 million records), so we partitioned the table into four file-groups. After we trunc'ed and re-loaded, we added about 80 GB of data to the new files. After we shrunk the database, however, the .mdf file stayed close to the same size as before we partitioned the table. We're running into space issues now; any suggestions? Why didn't we reclaim more space after shrinking the database?
Thanks much,
Jason