SQL Server filegroup resolves large data volume data storage

How to use filegroups to solve the poor reading and writing performance of large data volumes, the following steps:

In Enterprise Manager, right-click your database, select Properties, select Data file, add one, fill in the file, fill in the location, file group, such as ABC---OK.

Then you can right-click on the table in your database, design the table, then right-click Properties, and then change the table filegroup and text file group to ABC, the original table from the original large MDF file into your new file.

Add the file, the same way, the purpose is to split the main file (MDF) into multiple files, the advantage of using the file group is not to change the database data, can be the existing MDF file split into multiple

Finally, be sure to use DBCC SHRINKDATABASE (yourdatabase) to shrink your database, or you won't see the actual size of your original MDF file after it was split.

Conclusion: Using filegroups can improve the I/O performance of the database.

SQL Server filegroup resolves large data volume data storage