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: