Daniel Lemire

FEBRUARY 8, 2019

I believe that all optimizing C/C++ compilers know how to pull this trick and it is generally beneficial irrespective of the processor’s architecture. In concrete terms, here is the C code to compute the remainder of the division by some fixed divisor d : uint32_t d =. ; // your divisor > 0. Can we do better?

C++ 279

C++ Benchmarking Hardware Testing 279

SQL Performance

AUGUST 12, 2020

T-SQL supports it starting with SQL Server 2005. What’s different about the design of CTEs compared to derived tables is where in the code these three elements are located. However, there are very few cases in T-SQL where without a terminator the code is ambiguous. The elements are sort of intertwined.

C++ 140

C++ Code Design Database 140

SQL Performance

OCTOBER 9, 2019

Consequently, handling our task becomes a no-brainer: DECLARE @s AS VARCHAR ( 20 ) = '123.456.789,00' ; SELECT TRANSLATE ( @s , '.,' , ',' ) ; This code generates the desired output: 123,456,789.00. databases ; OPEN C ; FETCH NEXT FROM C INTO @dbname ; WHILE @@FETCH_STATUS = 0. That's pretty neat!

C++ 111

C++ Database Servers Code 111

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. 75 Test XYZ Student C 55 Test XYZ 77.5 75 Test XYZ Student C 55 Test XYZ 77.5 75 Test XYZ Student C 55 Test XYZ 77.5 You can download this sample database here.

Servers 142

Servers Testing C++ Code 142

Smashing Magazine

DECEMBER 2, 2021

Advent of Code. If you prefer a puzzle over an article, take a look at Advent of Code. C# Advent Calendar. It’s time for the fifth annual C# advent calendar that will feature two pieces of content every day. Code Security Advent Calendar. It launched in 2005 and still has all of the calendars available online.

Design 110

Design Development Programming Website 110

Rigor

JANUARY 13, 2020

Steve Souders, plus Dion Almaer, Doug Crockford, Ben Galbraith, Tony Gentilcore, Dylan Schiemann, Stoyan Stefanov, Nicole Sullivan, Nicholas C. The in-depth explorations are meticulously illustrated and code examples culminate as bulletproof code snippets, applicable to your work right away. ” – Andy King, 2003.

Performance 75

Performance Social Media Website Website Performance 75

Brendan Gregg

AUGUST 8, 2017

Nowadays, the source code to old operating systems can also be found online. TABLE OF EXP(-T/C) FOR T = 5 SEC. EXPFF: EXP 0.920043902 ;C = 1 MIN EXP 0.983471344 ;C = 5 MIN EXP 0.994459811 ;C = 15 MIN. Linux is also hard coding the 1, 5, and 15 minute constants. This, too, was a dead end. was missing.

Latency 111

Latency Metrics C++ Systems 111