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 ?

just a little caution:
If you have an alert activating a job, and you disable the job without disabling the alert, your SQLAGENT.OUT file will explode because it still...

Avoid the trace flag. (as it is no longer a tweek)   Use the configuration setting.

FYI, we recently discovered a heap table, with no indexes at all, consuming 56GB having only +/-40000 rows of 64bytes.
(SQL2014 SP2CU3)
After 'alter table x REBUILD', consumption got back...

A couple of years ago I started pistol target shooting, because that needs a focussed mind. It worked very well.
Nowadays, I find my best relaxation doing mantrailing...

..

UPDATE ED
SET ED.ID = ET.SID,
ED.Code = ET.TCode,
FROM dbo.Emp ED
INNER JOIN dbo.EXt ET
  ON...

There's the main difference between log shipping and db mirroring !

see = "... A log shipping process is always unidirectional ....."  

Also have a...

If you have your files set to Autogrow: Check your default traces, they contain info on automatic file growth !

/*
* read SQL default trace...

ALTER COLUMN: https://msdn.microsoft.com/en-us/library/ms190273.aspx

"Modify columns" https://msdn.microsoft.com/en-us/library/ms190259.aspx

implicit conversions https://msdn.microsoft.com/en-us/library/ms187928.aspx

it depends, for some data type changes it has to rewrite the whole table to get all internal stuff in order. ( e.g. from char to varchar, varchar to nvarchar, float to...

This is the sequence I use:

-- 0 = db file info
-- 1 = backup log
-- 2 = Shrink log file
-- 3 = extend...

My guidelines for FK-indexes: Always put an index on the FK columns, unless that hurts the performance of that particular system. ( i.e. your milage may vary ! )