Knowing the algorithm will not actually allow you to predict what will happen when. All kinds of delays that happen in the execution of a program or thread are dependent on environmental conditions such as: available memory, swapping, incoming interrupts, other busy tasks, etc. If you were to map your multi-threaded program to a sequential … Read more
You just need to create it with schemabinding. SQL Server will then verify whether or not it meets the criteria to be considered as deterministic (which it does as it doesn’t access any external tables or use non deterministic functions such as getdate()). You can verify that it worked with SELECT OBJECTPROPERTY(OBJECT_ID(‘[dbo].[FullNameLastFirst]’), ‘IsDeterministic’) Adding the … Read more
Just what is this “hint” to the runtime? As you conjecture, the compiler tracks whether a conversion to double or float was actually present in the source code, and if it was, it always inserts the appropriate conv opcode. Does the C# spec stipulate that an explicit cast to float causes the insertion of a … Read more
Update: In Python 3.6, dict has a new implementation which preserves insertion order. From Python 3.7, this order-preserving behaviour is guaranteed: the insertion-order preservation nature of dict objects has been declared to be an official part of the Python language spec. This is the result of a security fix from 2012, which was enabled by … Read more