Deterministic elements always return the same result any time they are called, with the same input. SQL Server include built-in system functions, stored procedure 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 we 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 tricks and tips on how to work around those behaviors in order to make our system more consistent.