SQL Performance

AUGUST 12, 2020

What’s different about the design of CTEs compared to derived tables is where in the code these three elements are located. However, there are very few cases in T-SQL where without a terminator the code is ambiguous. The elements are sort of intertwined. In those cases, the termination is mandatory. Incorrect syntax near 'UC'.

C++ 140

C++ Code Design Database 140

Sutter's Mill

SEPTEMBER 28, 2023

Started self-hosting I haven’t spent a lot of time yet converting cppfront’s own code from today’s syntax 1 to my alternate syntax 2 (which I’m calling “Cpp1” and “Cpp2” for short), but I started with all of cppfront’s reflection API and metafunctions which are now mostly written in Cpp2.

C++ 96

C++ Cache Code Design 96

SQL Performance

MAY 24, 2022

This clause allows you to shorten your code by avoiding the repetition of identical parts of your window specifications. As an example where the WINDOW clause can be handy in shortening your code, consider the following query: USE TSQLV6 ; SELECT orderid , custid , orderdate , qty , val , SUM ( qty ) OVER ( PARTITION BY custid.

Servers 145

Servers C++ Code Database 145

The Netflix TechBlog

OCTOBER 14, 2024

Naturally, you would think that there must be something wrong with the code running in it. Upon closely examining the user’s Notebook, we noticed a library called pystan , which provides Python bindings to a native C++ library called stan, looked suspicious. That means the code starts more processes than the number of CPUs.

Latency 211

Latency Virtualization Traffic Processing 211

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

C++ Virtualization Lambda Code 95

SQL Performance

MAY 13, 2020

I just wanted to mention some use cases here to illustrate how important table expressions are in our T-SQL code, and why it's worthwhile to invest in understanding their fundamentals well. Here's the standard's definition for derived tables in the general sense: 4.15.3 C is what's known as a range variable. Derived tables.

C++ 143

C++ Code Design Servers 143

DZone

NOVEMBER 9, 2021

It sits at the very beginning of the process before the code is written and can save an immense amount of time down the road (of somebody spending tons of time just to get to a dead-end). I really like what one of the smartest people with whom I worked said: “A good design is a design where you can see the code”. Important note.

Software 245

Software Software Code Design 245

Dynatrace

AUGUST 7, 2023

Developers use generative AI to find errors in code and automatically document their code. They can also use generative AI for cybersecurity, write prototype code, and implement complex software systems. Visit our booth, number #2608, at Black Hat and c heck out our guide below. Here’s what you need to know.

DevOps 197

DevOps Analytics Best Practices Java 197

SQL Performance

JANUARY 13, 2021

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

C++ 113

C++ Code Testing Processing 113

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

C++ Open Source Database Programming 83

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

O'Reilly

APRIL 25, 2023

At a glance, it’s clear that the prompts Xu Hao uses to generate working code are very long and complex. While I didn’t count lines, I would guess that the total length of the prompts is greater than the number of lines of code that ChatGPT created. First, note the overall strategy Xu Hao uses to write this code.

Programming 131

Programming Architecture Code Strategy 131

SQL Performance

MARCH 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. BatchMe ; GO. CREATE TABLE dbo. BatchMe ON 1 = 0. and dbo.T3

C++ 134

C++ Testing Code Servers 134

SQL Performance

JULY 13, 2022

This could also happen if you need to migrate code written for another database platform with a different dialect of SQL to T-SQL. Use the following code to create the Orders table and populate it with a small set of sample data to help you verify the validity of the solutions: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo.

C++ 112

C++ Code Azure Database 112

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.

C++ 124

C++ Servers Testing Code 124

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. dt and the other with C2.dt.

C++ 122

C++ Code Storage Processing 122

Sutter's Mill

JUNE 3, 2021

Briefly, what is the difference among: (a) undefined behavior Undefined behavior is what happens when your program tries to do something whose meaning is not defined at all in the C++ standard language or library (illegal code and/or data). By definition, if a function’s preconditions are violated, then the results are not specified.

C++ 72

C++ Programming Lambda Code 72

Sutter's Mill

JANUARY 11, 2021

Assertions have been a foundational tool for writing understandable computer code since we could write computer code… far older than C’s assert() macro, they go back to at least John von Neumann and Herman Goldstine (1947) and Alan Turing (1949). 1,2] How well do we understand them… exactly? GUIDELINE: Assert liberally. [3]

C++ 78

C++ Programming Code Testing 78

Dynatrace

NOVEMBER 8, 2021

G2 Research includes a clear definition of APM in its Grid Report for Application Performance Monitoring for Spring 2021. The right APM tool will also help you keep a close eye on application transactions along with their business context and code-level detail. ” — Christopher C, Platform Manager at an enterprise.

Artificial Intelligence 239

Artificial Intelligence Monitoring Infrastructure Cloud 239

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

C++ 136

C++ Strategy Testing Servers 136

Scalegrid

FEBRUARY 15, 2024

MongoDB® SSL with Self-Signed Certificates in C# Configuring MongoDB Server for SSL/TLS Encryption Once your certificates are ready, the next step is configuring the MongoDB server for SSL/TLS encryption, allowing you to securely connect to MongoDB. While we’re yet to run comprehensive tests, there is definite overhead due to using SSL.

Servers 130

Servers Best Practices Government Network 130

SQL Performance

MARCH 11, 2020

To demonstrate the T-SQL implementation of a unique constraint, run the following code, which creates a table called T3 with a unique constraint defined on the NULLable INT column col1, and populates it with a few sample rows: USE tempdb ; GO. The standard unique constraint definition is a bit different than the T-SQL version.

C++ 135

C++ Code Servers Database 135

The Morning Paper

NOVEMBER 12, 2019

Scaling symbolic evaluation for automated verification of systems code with Serval Nelson et al., Here are the resulting code and specification sizes, together with the verification runtimes (impressively short!). SOSP’19. Serval is a framework for developing automated verifiers of systems software. Symbolic evaluation primer.

Code 45

Code Systems Programming Google 45

SQL Performance

JULY 27, 2021

As well as the nonclustered index correctness checks, if there’s a persisted computed column in the definition of a table, then for each data record in the table, DBCC CHECKDB has to check that the persisted value is correct, regardless of whether that column is part of a nonclustered index or not. columns [ c ] JOIN sys.

C++ 54

C++ Servers Database Code 54

Sutter's Mill

FEBRUARY 25, 2021

Explain your answer using the following example, which uses a variation of a proposed post-C++20 syntax for preconditions. [1] GUIDELINE: Use a precondition to write “this is what a bug is” as code the caller can check. A precondition states in code the circumstances under which this function’s behavior is not documented.

C++ 67

C++ Code Testing Systems 67

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. Use the following code to test the function with the variable assignment technique: DECLARE @n AS BIGINT ; SELECT @n = n FROM dbo. DROP TABLE IF EXISTS dbo.

C++ 112

C++ Servers Testing Code 112

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

Percona

OCTOBER 17, 2023

The dynamic allocation might have flaws, but it’s definitely a good addition. Shard Key Analyzer helper – analyzeShardKey() The shard key is a critical component of your cluster, as it dictates the distribution of your data through the shards, and that’s where the problem lies.

Metrics 105

Metrics C++ Database Storage 105

The Netflix TechBlog

MARCH 2, 2021

David Cameron (Studio Production) [David C.] My academic credentials definitely helped on the technical side. Coding with statistical software and SQL are my most widely used technical skills. What best prepared you for your current role at Netflix? Aliki Mavromoustaki (Content & Marketing) [Aliki M.]

Analytics 213

Analytics C++ Innovation Engineering 213

CSS Wizardry

JULY 21, 2018

le|c|sa|sc)ss$/{print}' | nl. This very non-scientific method of checking code usage should give you an approximate idea of what might be dead code, or what you might simply be able to ignore. For a slightly more robust, but still imperfect method of identifying dead code, try this technique that I wrote up earlier in 2018.

Programming 142

Programming C++ Code Database 142

SQL Performance

OCTOBER 1, 2020

In my last post , I showed how to use TSqlParser and TSqlFragmentVisitor to extract important information from a T-SQL script containing stored procedure definitions. And with the Visitor code I provided, the output to the console was: ==. Param name: @c. AS PRINT 1 ; GO. ProcedureReference. ==. dbo.procedure1. ==. Default: -64.

C++ 57

C++ Code Database Systems 57

Testsigma

APRIL 8, 2020

Then the code can be refactored to improve its quality. 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. Having clear behaviour visibility results in quality code which reduces the cost of maintenance and eliminates the risk.

Development 96

Development Programming Testing Java 96

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. We wanted AWS to grow its platform functionality, and to continually eat away at the bottom of the thin layer of rapidly evolving Netflix specific platform code that we had built.

Engineering 137

Engineering Serverless Lambda AWS 137

Smashing Magazine

JULY 18, 2022

If you think that static rendering is limited to generic, public content that is the same for every user of your website, you should definitely read this article. There was something he wanted to C."; If anything makes the JavaScript code fail, the paid user won’t have their dose of fun and might get angry. Eric Burel.

Cache 118

Cache Website Servers Energy 118

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

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. You can download the source code to create and populate this database here. The following query, which I’ll refer to as Query 5, illustrates this technique: WITH C AS. ( Environment for Demos.

C++ 133

C++ Database Servers Code 133

Percona

JUNE 7, 2023

Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database schema. Let’s see an example that throws an error if the table name does not start with ‘tbl_’ Similar code can be developed for any object.

Database 78

Database Best Practices Open Source C++ 78