One of our corporate standards to is have a separate filegroup/file for user tables/indexes. This is set as the default so no need to qualify CREATE TABLE statements.
So it looks like this
- fileid 1 = system tables, MDF
- fileid 2 = t-log = LDF
- fileid 3 = user stuff = NDF
Can anyone here help me understand the original justification why this was mandated?
I'll come clean and state I think it's voodoo. Am I wrong...?
Edit: I am aware of how to use filegroups for separation of indexes/partitions/archives, as well as how to restore piecemeal. This question is about the use of a separate filegroup on the same volume for system tables only.