Community

What’s the difference between Files and Filegroups?

(Kenneth Fisher) tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct used to store information (log & data) about the database.