Database Reference
In-Depth Information
Figure 15-11.
Data placement after new files have been created
When you run the
DBCC SHRINKFILE(Orders2013_01,emptyfile)
command, data from the
Orders2013_01
file
would be moved to three other files, as is shown in Figure
15-12
. Part of the data is moved to the
Orders2013_02
file
even though you are going to remove this file in the next step. This unnecessary data movement from
Order2013_01
to
Orders2013_02
introduces I/O and transaction log overhead in the system.
Figure 15-12.
Data placement after the
DBCC SHRINKFILE(Orders2013_01,EMPTYFILE)
command and Orders2013_01
file removal