Questions tagged [non-deterministic]

Non-deterministic is a definition for an algorithm that isn't guaranteed to return the same result for multiple executions, even with the same input. Results can vary from run to run

Filter by
Sorted by
Tagged with
2
votes
1answer
140 views

How can I identify non deterministic updates occurring in my SQL Server?

SQL Server books online states Use caution when specifying the FROM clause to provide the criteria for the update operation. The results of an UPDATE statement are undefined if the statement ...
4
votes
1answer
2k views

Deterministic function for getting today's date

I am trying to create an indexed view using the following code (so that I can publish it to replication it as a table): CREATE VIEW lc.vw_dates WITH SCHEMABINDING AS SELECT DATEADD(day, DATEDIFF(day,...