Benchmarking Index Fragmentation With Popular Sequential GUID Algorithms

In a multi-tenant data insert scenario, GUID is a great data type for primary key. Since it is unique globally, you will not need to rely on any range or custom logic. However, if you extend these columns as index, you will end up with frequent index fragmentation and hence bad performance. In this post,…

0

Check If Your Processor Has AVX Instruction Support

If you are trying to develop applications in Q# (Quantum Computing), then you would require support of AVX instruction set in your processor. While Microsoft is working on removing this limitation as of today, it may take a while before the limitation is removed. If your processor is shipped On or after Sandy Bridge (2011)…

0