SQL Performance

AUGUST 12, 2020

Customers WITH ( SERIALIZABLE ) ; The potential for ambiguity is when you have an unterminated statement preceding a CTE definition, in which case the parser might not be able to tell whether the WITH clause belongs to the first or second statement. Here’s an example demonstrating this: SELECT custid , country FROM Sales.

C++ 140

C++ Code Design Database 140

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

MAY 13, 2020

Here's the standard's definition for derived tables in the general sense: 4.15.3 There are three main parts to identify in a statement involving a derived table definition: The table expression (the inner query). However, from relational theory's standpoint, there's a deeper meaning to what C represents. Derived tables.

C++ 143

C++ Code Design Servers 143

SQL Performance

MAY 24, 2022

WHERE custid IN ( 1 , 2 ) WINDOW P AS ( PARTITION BY custid ) , PO AS ( P ORDER BY orderdate , orderid ) , POF AS ( PO ROWS UNBOUNDED PRECEDING ) ORDER BY custid , orderdate , orderid ; The order of the window name definitions in the WINDOW clause is insignificant. OrderValues. OrderValues.

Servers 145

Servers C++ Code Database 145

The Netflix TechBlog

MARCH 2, 2021

David Cameron (Studio Production) [David C.] My academic credentials definitely helped on the technical side. What best prepared you for your current role at Netflix? Are there any experiences that particularly helped you bring a unique voice/point of view to Netflix? Aliki Mavromoustaki (Content & Marketing) [Aliki M.]

Analytics 219

Analytics C++ Innovation Engineering 219

SQL Performance

MARCH 10, 2021

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. Here’s the function’s definition: CREATE OR ALTER FUNCTION dbo.

C++ 134

C++ Testing Code Servers 134

SQL Performance

JANUARY 13, 2021

L0 AS ( SELECT 1 AS c. Here’s the function’s definition: CREATE OR ALTER FUNCTION dbo. L0 AS ( SELECT 1 AS c. For this reason, compile times should definitely be taken into account—especially when using the function very frequently with small ranges. L0 AS ( SELECT 1 AS c.

C++ 113

C++ Code Testing Processing 113

SQL Performance

DECEMBER 9, 2020

L0 AS ( SELECT 1 AS c. Figure 1: Plan for base CTE cardinality of 2.

C++ 114

C++ Servers Testing Processing 114

Dynatrace

NOVEMBER 8, 2021

G2 Research includes a clear definition of APM in its Grid Report for Application Performance Monitoring for Spring 2021. ” — Christopher C, Platform Manager at an enterprise. APM solutions track key software application performance metrics using monitoring software and telemetry data.

Artificial Intelligence 240

Artificial Intelligence Monitoring Infrastructure Cloud 240

SQL Performance

FEBRUARY 10, 2021

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. SET NOCOUNT ON ; DECLARE @c INT = 0 ; WHILE @c < 128. MySYSDATETIME ( ) AS dontinline.

C++ 124

C++ Servers Testing Code 124

Percona

NOVEMBER 1, 2023

version, like this: ANALYZE TABLE removes the table from the table definition cache, which requires a flush lock. This makes the query wait for any long-running queries to finish but also can trigger cascading waiting for other incoming requests. In short, ANALYZE could lead to nasty stalls in busy production environments.

Servers 103

Servers Database Cache C++ 103

SQL Performance

NOVEMBER 11, 2020

WITH C AS ( SELECT SYSDATETIME ( ) AS dt ) SELECT @i += 1 FROM C WHERE dt = dt ; PRINT @i ; GO. -- Batch 3. WITH C AS ( SELECT SYSDATETIME ( ) AS dt ) SELECT @i += 1 WHERE ( SELECT dt FROM C ) = ( SELECT dt FROM C ) ; PRINT @i ; GO. ) SELECT C1. orderid , C1.

C++ 122

C++ Code Storage Processing 122

O'Reilly

JANUARY 9, 2024

Python is an interpreted language, so there’s no machine code, but there’s no reason this loop couldn’t incorporate a C or C++ compiler. With C or Python, you can read a program and understand exactly what it does. Google’s Bard has similar capabilities. However, the status of this repository was still shaky. At least, not yet.

Programming 115

Programming C++ Code Operating System 115

Percona

APRIL 10, 2023

Then, each key-value entry will keep in the key the column name surrounded by backticks, and the value will be the masking function definition. mydumper -o data -B test --defaults-file=mydumper.cnf -r 100000 -c real 0m19.964s user 0m48.396s sys 0m7.885s It took near 19.9 sbtest1`] `k`=random_int The backup took 20.7

Testing 113

Testing C++ Open Source Database 113

Sutter's Mill

APRIL 30, 2012

I’m seeing many younger programmers picking up C++. The average age at C++ events over the past year has been declining rapidly as the audience sizes grow with more and younger people in addition to the C++ veterans. Having that computer was definitely worth a year of predawn paper delivery in the rain, sleet, and snow.

C++ 40

C++ Programming Media Games 40

The Netflix TechBlog

MARCH 25, 2019

In the rest of this blog, we will a) touch on the complexity of Netflix cloud landscape, b) discuss lineage design goals, ingestion architecture and the corresponding data model, c) share the challenges we faced and the learnings we picked up along the way, and d) close it out with “what’s next” on this journey.

Infrastructure 226

Infrastructure Big Data Transportation Architecture 226

DZone

NOVEMBER 9, 2021

There are some languages (like C++) where this should be on the must-have list. There are some languages (like C++) where this should be on the must-have list. There are some languages (like C++) where this should be on the must-have list. larger topics, including problem definition, documentation, UX, design, etc.).

Software 245

Software Software Code Design 245

Sutter's Mill

SEPTEMBER 28, 2023

file compilation looks like when compiled on the command line on my laptop: But note you can still build cppfront as all-today’s-C++ using any fairly recent C++20 compiler because I distribute the sources also as C++ (just as Bjarne distributed the cfront sources also as C). Here’s what that reflect.h2

C++ 100

C++ Cache Code Design 100

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

JULY 21, 2018

le|c|sa|sc)ss$/{print}' | nl. These tags allow definitions to be quickly and easily located by a text editor or other utility. Basically, ctags will create a kind of of database of all of the function, variable, mixin, ID, and class definitions for your project. This output will not be listed chronologically.

Programming 144

Programming C++ Code Database 144

Sutter's Mill

SEPTEMBER 3, 2024

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. Perhaps you can relate, if you’ve ever said, “I’m pretty sure the answer is X, but this part of C++ is so complex that I’m not sure of myself.”

C++ 76

C++ Code Programming AWS 76

Smashing Magazine

NOVEMBER 23, 2021

John C Barstow. It follows best practices, tries to present a strong visual identity, has good contrast levels, and uses Overpass for headings and body, which provides a unified and legible sans serif family of typefaces: See the Pen [Dyslexia-unfriendly design]([link] by John C Barstow. Adding A Dyslexia-Friendly Mode To A Website.

Website 134

Website C++ Best Practices Design 134

All Things Distributed

DECEMBER 1, 2016

We also added C# support for AWS Lambda. We're excited to see how customers you will put these new features to work. *: Sean Connery is the definitive Bond. Lambda@Edge : Enable Lambda functions in Edge locations, and run functions in response to CloudFront events. Thirteen new services and major features focused on developers.

AWS 139

AWS Development Lambda Open Source 139

SQL Performance

JULY 13, 2022

L0 AS ( SELECT 1 AS c. But what if you require a deterministic definition of the frame with guaranteed repeatable results? To test the performance of the solutions, you’ll need a larger set of sample data. Orders WITH ( TABLOCK ) ( orderid , orderdate , empid , custid , qty ) SELECT N.

C++ 112

C++ Code Azure Database 112

Dynatrace

AUGUST 7, 2023

Visit our booth, number #2608, at Black Hat and c heck out our guide below. By definition, zero-day attacks take organizations by surprise. These are just some of the themes we will explore in our guide for Black Hat 2023, which takes place August 5-10 in Las Vegas.

DevOps 198

DevOps Analytics Best Practices Java 198

Percona

DECEMBER 29, 2022

for lib in $(psql -qtA pgbench -c"select extname||'.so' for lib in $(psql -qtA pgbench -c"select extname||'.so' Also, you will see a section with the explicit creation of the C language functions for the extensions. A custom C function is using it. For example, with the following bash snippet.

C++ 84

C++ Open Source Database Programming 84

SQL Performance

MARCH 11, 2020

The standard unique constraint definition is a bit different than the T-SQL version. Here's the unique constraint definition from the standard: "A unique constraint on T is satisfied if and only if there do not exist two rows R1 and R2 of T such that R1 and R2 have the same non-NULL values in the unique columns.". 5 NULL 300 D.300

C++ 135

C++ Code Servers Database 135

SQL Performance

APRIL 13, 2022

Note the definition of the primary key constraint based on the composite key (grp, ord), which results in a clustered index based on the same key. L0 AS ( SELECT 1 AS c. Following is the first solution to our challenge, which is based on a technique that has been known for a while: WITH C AS. (

C++ 136

C++ Strategy Testing Servers 136

SQL Performance

AUGUST 2, 2019

I restored a copy of WideWorldImporters and then created three stored procedures (definitions below). OrderID , c. Customers c ON o. CustomerID = c. OrderID , c. OrderID , c. Customers c ON o. CustomerID = c. OrderID , c. OrderID , c. Customers c ON o. CustomerID c.

Servers 95

Servers C++ Testing Systems 95

SQL Performance

APRIL 14, 2021

Here’s the function’s definition: -- Helper dummy table. BatchMe ( col1 INT NOT NULL , INDEX idx_cs CLUSTERED COLUMNSTORE ) ; GO. -- Function definition. b FROM L1 AS A CROSS JOIN L1 AS B CROSS JOIN L1 AS C ) INSERT INTO dbo. Here’s the function’s definition: CREATE OR ALTER FUNCTION dbo. BatchMe ; GO.

C++ 112

C++ Servers Testing Code 112

Adrian Cockcroft

FEBRUARY 9, 2023

The third is that the Team Topologies book defined how to create and manage Platform Teams so there’s interest in the terminology and definition. The second is that some companies with tools to sell are marketing the term. Talking through the map, we start with an end user who can choose a web app or a mobile app.

Engineering 137

Engineering Serverless Lambda AWS 137

Testsigma

APRIL 8, 2020

Hands on with one of the programming languages (like JAVA (prefered), Python, Ruby, C#) that will be needed for automation of a test case in the backend. BDD is ineffective without a proper definition of business requirements since it does not cope well with poorly written user stories. Read more about step definitions here.

Development 96

Development Programming Testing Java 96

The Morning Paper

MAY 16, 2019

An especially interesting comparison can be made in the case of gRPC, which has both a C implementation and a Go implementation. The following table shows the ratio of the number of goroutines created in gRPC-Go compared to gRPC-C, when processing the same number of requests. 85 of the bugs were blocking, and 86 were non- blocking.

Programming 100

Programming C++ Design Code 100

CSS Wizardry

APRIL 25, 2019

I don’t think this article is definitive or gospel. The Head of Tech likely reports into C-level staff, so they’ll sit pretty close to the business, but might not have as much hands-on technical knowledge as a day-to-day engineer. I decided to write down (and expand on) my answer in the hope that it might help someone else, too.

Code 201

Code Engineering Design C++ 201

Percona

JULY 5, 2023

For example, you can’t dump and restore user definition: mysql 80 > show create user msandbox_ro@localhostG 1. source manually, as, again, this is not supported action: # orchestrator-client -c relocate -i 127.0.0.1:5749 Any changes in system tables made since the 8.0 version source will break the 5.7 replica under the 8.0

C++ 123

C++ Database Servers Testing 123

SQL Performance

MAY 11, 2022

Naturally, if a partitioning or ordering element doesn’t appear in the window function, you omit that part from the index definition. The following query, which I’ll refer to as Query 5, illustrates this technique: WITH C AS. ( Consider the following query, which I’ll refer to as Query 6: WITH C AS. ( max3: orderid.

C++ 133

C++ Database Servers Code 133

Smashing Magazine

AUGUST 9, 2021

For example, if we have files A, B, and C, we would have three TCP connections. You see, because TCP is a much older protocol and not made for just loading web pages, it doesn’t know about A, B, or C. You might think that’s not a big problem, as we see there is no loss for resources A and C. For HTTP/1.1, Large preview ).

Transportation 145

Transportation Internet Internet Network 145