Unless the rows are insanely wide, a 200,000 row insert is pretty much a cake walk for your initial insert.  And, it can be done using "Minimal Logging", which not...

We have no idea what you're table looks like, what indexes are available, nor any idea what the report is supposed to do/look like.  A bit more of a description...

I guess I don't understand the desire to partition by two columns, never mind the PeriodYTD column.  It would appear that the PERIOD column is based on month ending dates...

It does exactly what it says so it's not a document error.  It "compact{s}... based on the existing fill factor value".  The documentation also clearly states that REORGANIZE will NOT...

Stepping back to the original question of "Are Indexes Actually Changes to the System?", let's also consider that I've just run across a 14.5GB index with 16 key columns (8...