Remove c
article thumbnail

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

SQL Performance

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
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.

Trending Sources

article thumbnail

BPF Theremin, Tetris, and Typewriters

Brendan Gregg

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
article thumbnail

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

SQL Performance

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
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. For example, the open source Java library at the heart of the Log4Shell crisis in 2021 was patched within days given the pervasiveness of the code.

Cloud 186
article thumbnail

The DBCC_OBJECT_METADATA Latch

SQL Performance

Continuing my series of articles on latches, this time I’m going to discuss the DBCC_OBJECT_METADATA latch and show how it can be a major bottleneck for consistency checks prior to SQL Server 2016 under certain circumstances. But remember, this bottleneck only happens for versions of SQL Server earlier than SQL Server 2016.

C++ 54
article thumbnail

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

SQL Performance

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