Remove c
article thumbnail

Fundamentals of table expressions, Part 7 – CTEs, optimization considerations

SQL Performance

Here’s the attempted solution using a CTE: WITH C AS. ( Using our trick with the TOP filter in the inner query, you prevent the unnesting of the table expression, like so: WITH C AS. ( The following code returns only shippers with a maximum order date that is on or after January 1 st , 2018: USE PerformanceV5 ; WITH C AS. (

C++ 140
article thumbnail

Draft FAQ: Why does the C++ standard ship every three years?

Sutter's Mill

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. Of course, and no.

C++ 98
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Which is the Best MongoDB GUI? — 2019 Update

Scalegrid

In 2014, we discussed 4 of the top MongoDB GUIs: MongoVue, MongoHub, RockMongo, and Robo 3T (formerly Robomongo), and again in 2016: MongoDB Compass, Robo 3T, Studio 3T, and MongoBooster. Query Code for converting queries to five target language: Java, Python, C#, PHP, and JavaScript (Node.js). The Best Mongo GUI’s of 2016.

article thumbnail

The challenge is on! Community call for creating the fastest number series generator

SQL Performance

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

C++ 114
article thumbnail

bpftrace (DTrace 2.0) for Linux 2018

Brendan Gregg

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. ply is also C, whereas bpftrace is C++. # Attaching 2 probes. ^C

C++ 105
article thumbnail

BPF Theremin, Tetris, and Typewriters

Brendan Gregg

Embedded C. # # Tone generation from: [link] # # 29-Apr-2019 Brendan Gregg Created this. This is the culmination of five years of work: the BPF kernel runtime, C support, LLVM and Clang support, the BCC front-end, and finally the bpftrace language. This is not my best code, since I hacked it in a hurry, but here it is: #!/usr/bin/python

C++ 85
article thumbnail

RSA Guide 2023: Cloud application security remains core challenge for organizations

Dynatrace

As digital transformation escalates, vulnerabilities are increasing as well, by more than 290% since 2016. According to a recent survey, even among organizations that have shifted left, 75% of C-suite executives say security challenges limit their ability to innovate.

Cloud 199