Nondeterministic Elements, Tips and tricks

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.

Ronen Ariely

Senior consultant and architect, data platform and application development.

Tel Aviv, Israel


Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top