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 локалност и одржување (архивирање на стари партиции)

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