If you are finding most top 10 steps for SQL Server Performance tuning, you could get one of the items in the list is “multiple file-groups and various data-files increases the query performance”.This is correct. You can move your fat table from master or primary data group to another custom file group. It gives you … Continue reading SQL Server: Move your Table from one File Group to another File Group