Sql server is able to optimize query plans when they use operators that are deterministic, because it can call the operator once, and then cache the result.
The are operators in the catalog that could be marked as deterministic, but are not. We need to go through and analyze which operators could be marked as deterministic and do so.
There are examples in #42