• SOLUTION: So without making major changes to the application or framework, we were able to tweak the query that fetches the data to filter out any records created in the last 5 seconds. Not an ideal fix (my vote was hekaton), but it's the one that worked for our needs right now. The amount of seconds can be tweaked again if network latency increases/decreases. If using a stored procedure, the second value could be parameterized so the schema doesn't have to change when latency changes.

    SELECT TOP(n)

    FROM dbo.bla

    WHERE CreateDt <= DATEADD(SECOND, -5, GETUTCDATE())

    There is no spoon. And there is no default sort order in SQL either.