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

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 Network 100

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

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 130

Programming Java Google C++ 130

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

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

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 107

Design Development Programming Website 107

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

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

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 166

Open Source Scalability Speed Efficiency 166

Smashing Magazine

JANUARY 7, 2019

Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. 2019-01-07T12:00:13+00:00. 2019-04-29T18:34:58+00:00. Ad Weight Impact If your site depends on the revenue generated by advertising, it’s useful to track the weight of ad related code.

Performance 103

Performance Cache Metrics Network 103

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

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++ 102

C++ Education Java AWS 102

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

Percona

MARCH 7, 2019

In other words, the time the CPU was executing user code, such as MySQL. 2019-02-22T18:26:25 Creating triggers. 2019-02-22T18:27:14 Created triggers OK. 2019-02-22T18:27:14 Copying approximately 4924071 rows. clients`: 94% 00:24 remain 2019-02-22T18:34:15 Copied rows OK. 2019-02-22T18:34:15 Analyzing new table.

C++ 102

C++ Traffic Servers Monitoring 102

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 136

Azure Serverless IoT Lambda 136

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

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

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++ 77

C++ Engineering Technology Technology 77

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 132

Google Ecommerce DevOps Cloud 132

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

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 Ecommerce DevOps 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

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

HammerDB

JUNE 27, 2022

Given the increasing importance of open source and the widespread use of HammerDB, the TPC adopted HammerDB in 2019 and now hosts the project on GitHub. HammerDB supports 2 workloads derived from TPC specifications to test these different requirements, namely TPROC-C derived from TPC-C for OLTP and TPROC-H derived from TPC-H for OLAP.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

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

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

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

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

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

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 126

Speed Java AWS Virtualization 126

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

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

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++ 45

C++ Lambda Efficiency Code 45

Sutter's Mill

AUGUST 13, 2023

Thanks again to C++ Now for inviting me to speak this year in glorious Aspen, Colorado, USA! The talk I gave there was just posted on YouTube, you can find it here: At CppCon 2022, I argued for why we should try to make C++ 10x simpler and safer , and I presented my own incomplete experimental compiler, cppfront.

C++ 89

C++ Efficiency Design Virtualization 89

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 Programming 87