Date: 2025-06-05 18:27:02
Score: 3
Natty:
I would recommend that instead of utilizing the PRIMARY file group I would suggest creating file groups with multiple files for data, indexes and text. It will definatly provide far better performance than PRIMARY.
https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-files-and-filegroups?view=sql-server-ver17#filegroups
Reasons:
- Probably link only (1):
- Low length (0.5):
- No code block (0.5):
- Low reputation (1):
Posted by: Raul Fernandez