consider FG_january_2011 file group contains 100000 records. and FG_january_2012 file group contains 2000 records.
update Table_Name set date=dateadd(yyyy,+1,date) where Year(date)=2011
if i execute this query, what will happen.?? my thought is FG_january_2011 file group 100000 records will move to FG_january_2012 file group. and records too incremented as 102000.Is it right things?? else what???
asked Aug 30, 2012 at 08:55 AM in Default
If your table is partitioned to different filegroups, on the date-column, the data will move to pages in the FG_january_2012 filegroup when you change the date-column.
answered Aug 30, 2012 at 12:33 PM
Filegroups don't really count storage based on rows of data. Instead, data is allocated by pages. You assigned tables to particular filegroups and as data is added to the tables, when more space is needed, pages are consumed. The rows are stored on pages based on your default free space options and the size of the data in the rows.
answered Aug 30, 2012 at 10:55 AM
Grant Fritchey ♦♦