79655018

Date: 2025-06-05 18:27:02
Score: 3
Natty:
Report link

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