Itzik Ben-Gan
sqlperformance.com/author/itzikbengan
Itzik Ben-Gan is a T-SQL trainer at and co-founder of Lucient. He is a Microsoft Data Platform MVP, author of many T-SQL books, and a regular speaker at SQL Server related conferences.
SQLBits 2023
Beware of nondeterministic T-SQL code
Nondeterministic calculations are calculations that when invoked repeatedly, return different results given the same inputs. Most T-SQL developers understand what nondeterministic calculations are, but many aren’t aware of the possible implications of using nondeterministic code. This session will show you the many surprising aspects of using nondeterministic code and will provide best practices that will help you avoid getting into trouble.
Nondeterministic calculations are calculations that when invoked repeatedly, return different results given the same inputs. Most T-SQL developers understand what nondeterministic calculations are, but many aren’t aware of the possible implications of using nondeterministic code. This session will show you the many surprising aspects of using nondeterministic code and will provide best practices that will help you avoid getting into trouble.