What are filegroups in SQL Server? A filegroup is a named container for data files, and an ordinary table or index lives in exactly one. This post builds a small demo, shows where a table lands, and gives honest advice on when extra filegroups help and when they only add work.
SQL SERVER – Beginning of SQL Server Architecture – Terminology
Beginning SQL Server Architecture: my friend Anil Kumar explains the basic terms and the main parts, the Relational Engine, Storage Engine and SQL OS.
Piecemeal Restore Quiz: What Happens to Tables Not Restored Yet?
This Piecemeal Restore Quiz asks what happens when a query reads a table whose filegroup is still offline. The answer is an error for that table only, while everything else keeps working. A tested script shows the error and then brings the last filegroup online.
Resource Database Quiz: Where Do the System Objects Live?
This Resource Database Quiz asks where SQL Server stores the definition of sys.objects and whether BACKUP DATABASE can protect it. The answer is the hidden Resource database. A tested script shows its version, its date and the system objects every database sees.
SQL Server for Oracle DBAs: The Vocabulary
SQL Server for Oracle DBAs translates instance, database, schema, tablespace, undo, and redo without pretending the two architectures are identical.
SQL SERVER – Generic Architecture Image
A Generic Architecture image of SQL Server I found on Wikipedia, with a short note on physical storage in MDF and LDF files and how data is grouped logically.