sit and wait. I guess it has to rewrite the whole table and its indexes. i.e. +190GB 
(I/O bound operation)
It all depends on the original datatype and length...

This will work when performing piecemeal restores (after primary FG has been restored):

Select ...
from sys.data_spaces DS
inner join sys.database_files F
   on F.data_space_id...

Already great work by Mark 🙂

I only came to this starting point:

Select  PlanXML.xmlnode.value('@FieldName', 'varchar(255)') AS FieldName
         , PlanXML.xmlnode.value('@FieldValue', 'varchar(255)') AS...

there seem to be a couple more parallel operations in the 58 plan vs the 3:45plan

Do you also monitor blocking operations in your system ?
Do these...

Best practices exist to be neglected.
Data consistency should not be dependant on the person doing the entry job.

replace " with no_wait" to "with rollback immediate" !

There can be dosens of reasons why a plan will get invalidated.
e.g. changes to indexes (rebuilds), create/drop index, statistics update, ...

Compare the old and the new plan...

Thank you,  Gail

In the mean while I stumbled upon this myth article covering the topic I've been pondering over.
SQL Server Urban Legend: SQL Server Uses...

indeed

First I believe someone just ran DTA and created all indexes and statistics that tool suggested.
Result:
- Way to many indexes
- user defined statistics 

Also: having...

You are using a view which calculates the value of a column you are using as a predicate in your original query.
So to be able to filter the result...

you do realize that your view is to be materialized due to all the functions you are performing in it to determin the content for colum C_Date, right ?