Creating New Databases

• Create a small file in the PRIMARY file group to hold the system information for the database. Create a second filegroup called Data to hold the table data. This way if the I/O capacity of the database files ever needs increased multiple data files can be created of the same size (to balance the load) and the original file in the Data filegroup removed. Example the data file grows to 500 GB, but is starting to show I/O pressure. Five 100 GB files could be created on different volumes and then the data moved from the original 500 GB file and it deleted. This creates a balanced load accross five files on five volumes. If the original file in the Primary filegroup is allowed to grow, it is harder to move the data later for balancing.