Changes between Initial Version and Version 1 of FileGroups

Timestamp:

02/08/26 16:18:00 (3 weeks ago)

Author:

185022

Comment:

--

FileGroups

@@ +1 @@
+= Filegroups по временски период
+
+[wiki:DataStoringOrganization Врати се назад]
+
+Креирани се `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
+
+}}}
+
+[wiki:DataStoringOrganization Врати се назад]