Deterministic elements always return the same result any time they are called with the same input.
SQL Server includes built-in system functions, stored procedures and other non-deterministic elements. The use of those might result in unexpected behavior.
For example, non-deterministic functions may return different results each time they are called with a specific set of input values.
In this session I will demonstrate several examples, we will identify the determinism of built-in system functions and the effect on the deterministic behavior of user-defined elements and T-SQL scripts.
We will focus on showing tips and tricks on how to work around those behaviors in order to make our system more consistent.
This Download includes these files: