SQL Performance

OCTOBER 14, 2020

Then, you will probably want to continue reading this section and test the code that I use as I revisit key unnesting examples that I previously demonstrated with derived tables and convert them to use CTEs. Here’s the attempted solution using a CTE: WITH C AS. ( You won’t miss anything important that you haven’t read before.

C++ 140

C++ Servers Code Efficiency 140

Sutter's Mill

JULY 13, 2019

More about that in the post-meeting trip report after the meeting is over… FAQs (As of pre-Cologne, July 2019) There are bugs in the standard, so should we delay C++20? If we had just another meeting or two, we could add <feature> which is almost ready, so should we delay C++20? Of course, and no.

C++ 98

C++ Entertainment Education Azure 98

The Netflix TechBlog

APRIL 17, 2019

Intel and Netflix announced their collaboration on a software video encoder implementation called SVT-AV1 on April 8, 2019. Reference software serves as the basis for standard development, a framework, in which the performance of video coding tools is evaluated. Furthermore, unit tests will cover new code. What is SVT-AV1?

Open Source 167

Open Source Scalability Speed Efficiency 167

O'Reilly

JANUARY 13, 2020

” Despite the slow rate of adoption, Java’s six-month release cadence has been trucking along—Java 12 dropped in March 2019, with Java 13 following in September. 2019 brought another surprise when Oracle moved Java SE to a subscription-based model. Or do people just not know about the benefits of 11 in containers?”

Programming 132

Programming Java Google C++ 132

O'Reilly

FEBRUARY 18, 2020

Growth is still strong for such a large topic, but usage slowed in 2018 (+13%) and cooled significantly in 2019, growing by just 7%. But sustained interest in cloud migrations—usage was up almost 10% in 2019, on top of 30% in 2018—gets at another important emerging trend. Still cloud-y, but with a possibility of migration.

Software Architecture 136

Software Architecture DevOps Data Engineering Architecture 136

SQL Performance

OCTOBER 13, 2021

Before implementing the function itself, here’s code to create a supporting index on the Sales.Orders table: USE TSQLV5 ; GO. Orders ( custid , orderdate DESC , orderid DESC ) INCLUDE ( empid ) ; And here’s the code to create the function, named Sales.GetTopCustOrders: CREATE OR ALTER FUNCTION Sales. plan_handle , Q.

Cache 144

Cache Strategy C++ Code 144

Sutter's Mill

NOVEMBER 24, 2024

On Saturday, the ISO C++ committee completed the third-last design meeting of C++26, held in Wrocaw, Poland. There are just two meetings left before the C++26 feature freeze in June 2025, and C++26 is on track to be completed two more meetings after that in early 2026. is the nutshell synopsis. Thank you, Hana!

C++ 61

C++ Code Education Design 61

SQL Performance

SEPTEMBER 12, 2019

The main benefit of the PIVOT operator is that it tends to result in shorter code. However, this operator has a few shortcomings, among them an inherent design trap that can result in bugs in your code. You can find a clue that will help you figure out the bug in the code by looking at the query plan shown in Figure 1.

Best Practices 103

Best Practices C++ Code Design 103

SQL Performance

FEBRUARY 12, 2020

According to the standard, you would use the following code with the DISTINCT predicate to handle this need: SELECT orderid , shippeddate FROM Sales. According to the standard, you would use the following code to handle such a join: SELECT T1. Here's the complete solution code: WITH C AS. ( INNER JOIN dbo.

C++ 120

C++ Code Servers Database 120

SQL Performance

DECEMBER 11, 2019

Like them or not, as a database practitioner you often have to deal with them, and given that NULLs do add complexity to your SQL code writing, it's a good idea to make it a priority to understand them well. This query generates the following output: orderid shippeddate -- -- 10771 2019-01-02 10794 2019-01-02 10802 2019-01-02.

Best Practices 117

Best Practices C++ Database Code 117

Scalegrid

JUNE 18, 2019

To keep the example simple, we have specified the connection string and the cert file path directly in the code snippet – you would generally either put them in a yaml file or specify them as environment variables. 1305:12 @(shell):1:1 2019-04-18T19:44:42.261+0530 I NETWORK [thread1] trying reconnect to SG-example-1.servers.mongodirector.com:27017

C++ 100

C++ Servers Database Testing 100

SQL Performance

DECEMBER 9, 2020

Use the following code to run a test with base CTE cardinality of 2 (requires 5 additional levels of CTEs): DECLARE @low AS BIGINT = 1 , @high AS BIGINT = 100000000 ; WITH. Make sure that you enable Discard results after execution in your SSMS Query Options dialog under Grid, Results.

C++ 114

C++ Servers Testing Processing 114

The Morning Paper

SEPTEMBER 20, 2020

For example, think of the classic diamond pattern where A depends on B and C, and B and C both in turn depend on D, but there is no version of D that satisfies the constraints of both B and C. Adding a direct dependency to pin a version, even when it’s not truly a direct dependency of the project (another code smell!).

Monitoring 137

Monitoring Java C++ Strategy 137

Smashing Magazine

DECEMBER 2, 2021

Advent of Code. If you prefer a puzzle over an article, take a look at Advent of Code. Back in October of 2019, “Perl 6” was renamed to “Raku”. 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.

Design 110

Design Development Programming Website 110

SQL Performance

APRIL 13, 2022

Use the following code to create a table called T1 and populate it with a small set of sample data: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. Use the following code to create the helper function GetNums: CREATE FUNCTION dbo. L0 AS ( SELECT 1 AS c. I recommend you try to find a solution before implementing mine.

C++ 136

C++ Strategy Testing Servers 136

Dynatrace

APRIL 5, 2021

Similar to AWS Lambda , Azure Functions is a serverless compute service by Microsoft that can run code in response to predetermined events or conditions (triggers), such as an order arriving on an IoT system, or a specific queue receiving a new message. Dynatrace news. What is Azure Functions? When not to use Azure Functions.

Azure 139

Azure Serverless IoT Lambda 139

SQL Performance

APRIL 10, 2019

Use the following code to create the table, populate it with some sample data, and query it: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. Ticker ; This code generates the following output: symbol tradedate price -. STOCK1 2019-02-12 150.00 STOCK1 2019-02-13 151.00 STOCK1 2019-02-14 148.00 LAST ( C.

C++ 73

C++ Servers Virtualization Code 73

Smashing Magazine

JULY 16, 2019

2019-07-16T14:30:59+02:00. 2019-07-16T14:35:52+00:00. Note: Windows users will also need Microsoft Visual C++ 14.0, which you can grab from “Microsoft Visual C++ Build Tools” over here. First you’ll need to make sure you have a c-compiler on your system. The following code is to be entered into a python script.

Scalability 87

Scalability Website C++ Servers 87

SQL Performance

OCTOBER 9, 2019

WHERE orderdate = EOMONTH ( DATEADD ( month , - 1 , SYSDATETIME ( ) ) ) ; Note that if you actually run this query in the TSQLV5 sample database you will get an empty result since the last order date recorded in the table is May 6 th , 2019. That's pretty neat! TRIM is more than LTRIM(RTRIM()). SELECT name FROM sys.

C++ 111

C++ Database Servers Code 111

Dynatrace

JULY 13, 2020

refers to cloud-based, containerized, distributed systems, made up of cooperating microservices, dynamically managed by automated infrastructure as code. . ? C ontainers cannot be used at their full potential when only on their own. Containers and Microservices: R evolution in the architecture of distributed systems . ?

Google 133

Google DevOps Ecommerce Cloud 133

Smashing Magazine

JUNE 30, 2021

iOS empowers developers to easily parallelize code using Grand Central Dispatch , Android does this via their new, unified task scheduler WorkManager and game engines like Unity have job systems. How long your piece of JavaScript takes to finish depends on how fast the device is that your code is running on.

Games 145

Games Architecture Code C++ 145

Dynatrace

JULY 13, 2020

refers to cloud-based, containerized, distributed systems, made up of cooperating microservices, dynamically managed by automated infrastructure as code. . ? C ontainers cannot be used at their full potential when only on their own. Containers and Microservices: R evolution in the architecture of distributed systems . ?

Google 130

Google DevOps Ecommerce Cloud 130

SQL Performance

FEBRUARY 10, 2021

Here’s the code to create the dummy table: DROP TABLE IF EXISTS dbo. BatchMe ( col1 INT NOT NULL , INDEX idx_cs CLUSTERED COLUMNSTORE ) ; And here’s the code with the definition of the dbo.GetNumsAlanCharlieItzikBatch function: CREATE OR ALTER FUNCTION dbo. L0 AS ( SELECT 1 AS c. BatchMe ; GO. CREATE TABLE dbo.

C++ 124

C++ Servers Testing Code 124

Brendan Gregg

DECEMBER 22, 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++ 85

C++ Education Java AWS 85

SQL Performance

MAY 6, 2021

Part 3 started the query scan, performed some early phase processing, and started the first additional parallel tasks in branch C. Branch C execution details. Branch C (additional parallel tasks). At DOP 2, there are two new tasks, two worker threads, and two execution contexts for branch C. Branch C Parallel Execution.

C++ 95

C++ Azure Servers Processing 95

Brendan Gregg

OCTOBER 15, 2019

Dump of assembler code for function schedule: 0xffffffff819b6530 : callq 0xffffffff81a01cd0 < __fentry__ > 0xffffffff819b6535 : push %rbp [.]. Ctrl-C to end. ^C C FUNC COUNT aa_af_perm 1 [.truncated.] (gdb) disas schedule. That's at the start of _every_ kernel function on Linux. What the heck! Tracing "*". truncated.]

C++ 76

C++ Engineering Technology Technology 76

SQL Performance

MAY 11, 2022

You can download the source code to create and populate this database here. I ran all the examples on SQL Server ® 2019 Developer, where batch-mode on rowstore is available. The following query, which I’ll refer to as Query 5, illustrates this technique: WITH C AS. ( Environment for Demos. Figure 5: Plan for Query 5.

C++ 133

C++ Database Servers Code 133

Sutter's Mill

SEPTEMBER 3, 2024

Consider both correctness and usability convenience for calling code. We can hopefully do it even more simply and elegantly in C++26/29. Pre-C++11 answer I recently received this question in email from my friend Christopher Nelson. So, before reading further: What would be your answer? OK, have you got an answer in mind?

C++ 76

C++ Code Programming AWS 76

O'Reilly

MARCH 2, 2020

It’s not about getting software developers to write code faster. I don’t care what you call it, but large projects (a) are rarely successful, regardless of the methodology, because they (b) get overloaded with a lot of features that nobody needs but that sound good, and (c) forget what the customer or user really needs or wants.

Artificial Intelligence 21

Artificial Intelligence Software Architecture Programming C++ 21

Brendan Gregg

SEPTEMBER 25, 2021

The broken Java stacks turned out to be beneficial: They helped group together the os::javaTimeMillis() calls which otherwise might have have been scattered on top of different Java code paths, appearing as thin stacks everywhere. Without NMI, some kernel code paths (interrupts disabled) can't be profiled. But I'm not completely sure.

Speed 103

Speed Java AWS Virtualization 103

Randon ASCII

MARCH 30, 2020

I did my tests on an October 2019 version of Chromium’s code because that gave me the most flexibility about which build options to use. The graph below shows the relationship between the number of lines of code in source files and how long it took to compile them. million lines of source code in the primary source files.

C++ 87

C++ Code Open Source Testing 87

SQL Performance

OCTOBER 14, 2020

Then, you will probably want to continue reading this section and test the code that I use as I revisit key unnesting examples that I previously demonstrated with derived tables and convert them to use CTEs. Here’s the attempted solution using a CTE: WITH C AS. ( You won’t miss anything important that you haven’t read before.

C++ 52

C++ Servers Code Efficiency 52

Testsigma

APRIL 23, 2021

Simform (as of 2019) stated that an average user has at least 40 apps installed on their phones while millennials have around 67 apps. It also supports the testing of native, hybrid, and mobile web apps across various programming languages like Java, Ruby, C#, Javascript, PHP, Python. Being open-source, it also has a rich community! .

Testing Tools 86

Testing Tools Mobile Testing Open Source 86

SQL Performance

DECEMBER 9, 2020

Use the following code to run a test with base CTE cardinality of 2 (requires 5 additional levels of CTEs): DECLARE @low AS BIGINT = 1 , @high AS BIGINT = 100000000 ; WITH. Make sure that you enable Discard results after execution in your SSMS Query Options dialog under Grid, Results.

C++ 61

C++ Servers Testing Processing 61

Sutter's Mill

FEBRUARY 8, 2021

2] Explain your answer using the following example, which uses a variation of a proposed post-C++20 syntax for postconditions. [1] 2] Explain your answer using the following example, which uses a variation of a proposed post-C++20 syntax for postconditions. [1] How can we approximate those advantages? goto post; or _return_ =.;

C++ 62

C++ Lambda Code Efficiency 62

Brendan Gregg

OCTOBER 14, 2019

Dump of assembler code for function schedule: 0xffffffff819b6530 : callq 0xffffffff81a01cd0 < __fentry__ > 0xffffffff819b6535 : push %rbp [.]. Ctrl-C to end. ^C C FUNC COUNT aa_af_perm 1 [.truncated.] (gdb) disas schedule. That's at the start of _every_ kernel function on Linux. What the heck! Tracing "*". truncated.]

C++ 52

C++ Engineering Technology Technology 52

SQL Server According to Bob

MAY 19, 2019

As you can imagine, with a code base as large and vast as SQL Server, there is always room for improvement. There are a bunch of folks with compiler, linker, SQL Server code, testing and other disciplines who provided input. SQL Server 2019 builds DLLs and EXEs with 4KB file alignment to enable better demand paging.

IoT 61

IoT Servers Development Cache 61