SQL Performance

JULY 1, 2021

Here is a query to help you track them down using the sys.columns catalog view, but you're on your own for any explicit references that might exist in your application code: SELECT [ Schema ] = s. name , [ Column ] = c. name , [ Data Type ] = TYPE_NAME ( c. system_type_id <> c.

C++ 58

C++ Database Servers Performance 58

Sutter's Mill

JANUARY 25, 2021

We want a way to enable checking for some assertions but not others in the same code, because we may not always be able to afford expensive checks. If we could write all ideal assertions, and exercise all control flow and data flow during testing, then a failed assertion would definitely mean a bug in the same function where it was written.

C++ 45

C++ Programming Cache Testing 45

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. As an exercise, try solving this task with a pre-SQL Server 2017 compatible solution where you cannot use TRIM and TRANSLATE.

C++ 111

C++ Database Servers Code 111

Brendan Gregg

DECEMBER 21, 2019

In the video I explained how I arrived at tracing __iwl_dbg() in this way, and how you can follow a similar approach for tracing unfamiliar code. This is not my best code, since I hacked it in a hurry, but here it is: #!/usr/bin/python Embedded C. # # Tone generation from: [link] # # 29-Apr-2019 Brendan Gregg Created this.

C++ 52

C++ Education Java AWS 52

Brendan Gregg

DECEMBER 21, 2019

In the video I explained how I arrived at tracing __iwl_dbg() in this way, and how you can follow a similar approach for tracing unfamiliar code. This is not my best code, since I hacked it in a hurry, but here it is: #!/usr/bin/python Embedded C. # # Tone generation from: [link] # # 29-Apr-2019 Brendan Gregg Created this.

C++ 52

C++ Education Java AWS 52

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. JavaAdvent on Twitter. Stoyan Stefanov on Twitter. LeanUXmas on Twitter.

Design 107

Design Development Programming Website 107

SQL Performance

JUNE 10, 2020

That is, does SQL Server perform a substitution process whereby it converts the original nested code into one query that goes directly against the base tables? The answer is simple, to shorten the code by having the inner query use the infamous SELECT *. And if so, is there a way to instruct SQL Server to avoid this unnesting process?

C++ 109

C++ Database Servers Code 109

SQL Performance

JUNE 10, 2020

That is, does SQL Server perform a substitution process whereby it converts the original nested code into one query that goes directly against the base tables? The answer is simple, to shorten the code by having the inner query use the infamous SELECT *. And if so, is there a way to instruct SQL Server to avoid this unnesting process?

C++ 93

C++ Database Servers Code 93

HammerDB

APRIL 19, 2023

Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. This all sounded very similar to HammerDB TPROC-C workload (we will look at HammerDB TPROC-H (OLAP) another time), so it is easy for any reader to think both workloads are about the same. and 8.0.32

Performance 54

Performance Benchmarking Cache Storage 54

Sutter's Mill

MARCH 25, 2021

Some of these are exercised by the “wrong order” permutations above, but even call sites that remember the right argument order can make mistakes about the actual values. But is (b) always better than (c), in other examples? We limit the code that is responsible for maintaining the boolean condition. is_reachable?

C++ 45

C++ Design Code Systems 45

ScaleOut Software

AUGUST 20, 2020

This allows application code to introspect on the dynamic behavior of each data source, maintain synthetic metrics which aid the analysis, and create alerts when conditions require. They make use of standard object-oriented concepts and languages (such as C#, Java, and JavaScript). Debugging with a Mock Environment.

Cloud 52

Cloud Development Analytics Azure 52

ScaleOut Software

AUGUST 20, 2020

This allows application code to introspect on the dynamic behavior of each data source, maintain synthetic metrics which aid the analysis, and create alerts when conditions require. They make use of standard object-oriented concepts and languages (such as C#, Java, and JavaScript). Debugging with a Mock Environment.

Cloud 52

Cloud Development Analytics Azure 52

The Agile Manager

AUGUST 31, 2021

Every member creates the most comprehensive understanding they can of each story, which they express both through artifact (story narrative or code for example) and collaboration with other team members (story walkthroughs and desk checks). Good managers know how to work the problem and solution space.

Metrics 52

Metrics Design Engineering C++ 52

Nick Desaulniers

APRIL 18, 2014

“It’s written in ones and zeroes - binary code. So a whole Babel of computer languages has been created for programmers: FORTRAN, BASIC, COBOL, LISP, Pascal, C, PROLOG, FORTH. This blog is meant for those who don’t know x86-64 assembly, but maybe know a little C, and are curious about code generation.

C++ 98

C++ Programming Code Virtualization 98

Testlodge

AUGUST 9, 2023

The tester established a baseline by selecting the most critical, common, or obvious path through the code selection. Steps to Performing Basis Path Testing The first step is to create a control flow graph for a specified code section. The second step is to select a baseline path through the code.

Testing 75

Testing Software Software C++ 75

SQL Server According to Bob

FEBRUARY 10, 2019

– -c the control file. I started with a cmd file script exercising the connection path. We then found a few code paths in find login that did not switch to preemptive before making a call to SSSD or LDAP for Linux, AD activities. . – -S target server name forcing tcp protocol. – -T146 disable encrypted TDS.

Servers 40

Servers Network Database Systems 40

Sutter's Mill

MAY 1, 2023

Simple, mathematically safe, and efficient chained comparisons ( commit ) P0515 “Consistent comparison” (aka “spaceship”) was the first feature derived from this Cpp2 work to be adopted into the ISO Standard for C++, in C++20. Thank you again to everyone who helped land this Cpp2 feature in the ISO C++ Standard.

C++ 97

C++ Virtualization Lambda Code 97

CSS Wizardry

NOVEMBER 3, 2020

The whole point of the exercise that follows is to allow me to move quickly, spotting patterns from afar, and not having to do any slow or meticulous work yet. I want to be able to form hypotheses and draw conclusions without viewing a single URL or a line of source code. That work is what comes next. Final Word.

Speed 292

Speed Ecommerce Metrics Analytics 292

Percona

AUGUST 30, 2023

If a PostgreSQL user wants to change these values, they need to recompile the PostgreSQL from the source code. This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. psql "host=localhost user=postgres options='-c synchronous_commit=off'" psql (14.8) Type "help" for help.

Database 102

Database Servers Open Source Tuning 102

SQL Performance

APRIL 14, 2021

Use the following code to test the function with the variable assignment technique: DECLARE @n AS BIGINT ; SELECT @n = n FROM dbo. Here’s the code that creates the table and populates it using an INSERT statement with 102,400 rows to get it to be compressed: DROP TABLE IF EXISTS dbo. NullBits102400 ; GO. CREATE TABLE dbo.

C++ 112

C++ Servers Testing Code 112

The Morning Paper

DECEMBER 8, 2019

The Twizzler KVS (key-value store) is just 250 lines of C code, and uses one persistent object for the index structure, and a second one for the data. This is left as an exercise for the application developer at present. Cross-object pointers make this easy and natural. The FOT structure has some pros and cons. .

Hardware 56

Hardware Programming Media Storage 56

SQL Performance

SEPTEMBER 25, 2020

a AS /* comment here because -- chaos */ int = 5 , @b AS varchar ( 64 ) = 'AS = /* BEGIN @a, int = 7 */ ' 'blat' '' , @c AS int = -- 12. So I wrote some PowerShell code to step through a procedure to see which other tokens were identified. . -- AS BEGIN, @a int = 7 'blat' AS =. /* AS BEGIN, @a int = 7 'blat' AS = -- */. @a

Code 42

Code C++ Database Servers 42

John McCalpin

JANUARY 22, 2018

Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC. Instead, we found puzzle after puzzle. Instead, we found puzzle after puzzle.

Latency 40

Latency Hardware Code Testing 40