Having that history also lets you "roll forward" through time to see how your data ... VERSIONING = ON (HISTORY_TABLE = dbo.SalesOrderHistorical)); SQL Server will take care of updating the datetime ...

See performance gains by using indexed views in SQL Server Your email has been ... is stored by SQL Server so that it can be used as a virtual table to simplify queries and add a layer of security ...