= Filegroups по временски период

Креирани се `filegroups` за логичка/физичка сегментација на податоците:

* `FG_Old` (пред 2000)
* `FG_2000s` (2000-2009)
* `FG_2010s` (2010-2019)
* `FG_2020s` (2020-2029)
* `FG_Future` (2030+)

Причина: 
* подобро управување со големи податочни сетови (VLDB пристап)
* можност за backup/restore по filegroup
* подобра I/O локалност и одржување (архивирање на стари партиции)

{{{#!sql
alter database HospitalSyntheaDB add filegroup FG_Old;
go
alter database HospitalSyntheaDB add file (name='FG_Old', filename='C:\Users\User\Documents\DBA\FG_Old.ndf') to filegroup FG_Old;
go

alter database HospitalSyntheaDB add filegroup FG_2000s;
go
alter database HospitalSyntheaDB add file (name='FG_2000s', filename='C:\Users\User\Documents\DBA\FG_2000s.ndf') to filegroup FG_2000s;
go

alter database HospitalSyntheaDB add filegroup FG_2010s;
go
alter database HospitalSyntheaDB add file (name='FG_2010s', filename='C:\Users\User\Documents\DBA\FG_2010s.ndf') to filegroup FG_2010s;
go

alter database HospitalSyntheaDB add filegroup FG_2020s;
go
alter database HospitalSyntheaDB add file (name='FG_2020s', filename='C:\Users\User\Documents\DBA\FG_2020s.ndf') to filegroup FG_2020s;
go

alter database HospitalSyntheaDB add filegroup FG_Future;
go
alter database HospitalSyntheaDB add file (name='FG_Future', filename='C:\Users\User\Documents\DBA\FG_Future.ndf') to filegroup FG_Future;
go

}}}