Daniel Lemire

FEBRUARY 8, 2019

In some instances, libdivide can even be more efficient than compilers because it uses an approach introduced by Robison (2005) where we not only use multiplications and shifts, but also an addition to avoid arithmetic overflows. I make my benchmarking code available. What if d is a constant, but not known to the compiler?

C++ 279

C++ Benchmarking Hardware Testing 279

SQL Performance

FEBRUARY 17, 2022

Since SQL Server 2005, the trick of using FOR XML PATH to denormalize strings and combine them into a single (usually comma-separated) list has been very popular. On more than one occasion, I had to double-check the code was even mine. In the SQL Server 2005 days, I would have offered this solution: SELECT DISTINCT UserID , Bands =. (

Servers 82

Servers Code Efficiency Performance 82

SQL Performance

AUGUST 1, 2022

If you’ve been writing and optimizing T-SQL code for a while, you’re probably well aware of the many complexities involved with NULL handling. If you’re using T-SQL to compute percentiles as part of your work, these functions should be familiar to you since they’ve been supported in SQL Server 2005 and later. The Distinct Predicate.

Servers 142

Servers Testing C++ Code 142

IO River

NOVEMBER 2, 2023

‍You might keep introducing CDN-level features specific to CloudFront that significantly improve your application's performance. This means that if you wish to switch CDN, you’d have to rewrite a vast amount of code to support a new API.‍‍Sign Akamai tried to convince many users to use this new framework.

Lambda 52

Lambda AWS Cache Website 52

SQL Performance

MARCH 22, 2022

Both target performance and efficiency for workloads frequently submitting simple statements. Still, you should write code with both close to the front of your mind. For legacy applications or other third-party code that cannot be easily changed, explicit parameterization may not always be possible. Shell Plans.

Cache 61

Cache Servers Database Code 61

SQL Server According to Bob

JANUARY 11, 2020

As ​​ the ​​ administrator of a SQL Server 2005 installation, ​​ you will find that ​​ visibility into ​​ the ​​ SQL Server ​​ I/O ​​ subsystem ​​ has been ​​ significantly increased.

Servers 40

Servers Cache Database Media 40

IO River

NOVEMBER 2, 2023

You might keep introducing CDN-level features specific to CloudFront that significantly improve your application's performance. However, the IaC code significantly changes across each CDN provider.For example, the IaC code to provision a CloudFlare CDN and a CloudFront CDN is different in any IaC provider.

Lambda 52

Lambda AWS Cache Website 52