At a minimum, every [!INCLUDE ssNoVersion] database has two operating system files: a data file and a log file. Data files contain data and objects such as tables, indexes, stored procedures, and ...

Learn how to use the Filegroups tab in the Database Properties dialog box to view the filegroups of a database or to add a new filegroup. [!INCLUDE SQL Server] Use this page to view the filegroups or ...

As mentioned in my post on VLDBs, one of the key pieces of a high performing solution is the use of Read-only Filegroups. If a significant part of your data is not changing, then why not tell SQL ...