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

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

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 234

Artificial Intelligence Monitoring Infrastructure Cloud 234

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

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

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 114

Cache Website Energy Servers 114

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 207

Analytics C++ Innovation Engineering 207

SQL Performance

APRIL 14, 2021

I also love his efficient and eloquent writing style. Here’s the function’s definition: -- Helper dummy table. BatchMe ( col1 INT NOT NULL , INDEX idx_cs CLUSTERED COLUMNSTORE ) ; GO. -- Function definition. I love Paul White ’s work. DROP TABLE IF EXISTS dbo. BatchMe ; GO. CREATE TABLE dbo. CREATE OR ALTER FUNCTION dbo.

C++ 112

C++ Servers Testing Code 112

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

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

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

All Things Distributed

DECEMBER 1, 2016

Today, we're making available broad new services which that let builders prepare and operate their applications more quickly and efficiently, and respond to changes in both their business and their operating environment, swiftly. We also added C# support for AWS Lambda.

AWS 162

AWS Development Lambda Open Source 162

SQL Performance

JUNE 10, 2020

That is, does SQL Server perform a substitution process whereby it converts the original nested code into one query that goes directly against the base tables? Recall that a relation’s body—being a set of tuples—by definition has no duplicates. Unnesting/substitution/inlining: Does SQL Server unnest, or inline, the derived table query?

C++ 109

C++ Database Servers Code 109

HammerDB

FEBRUARY 25, 2021

For HammerDB both TPROC-C and TPROC-H run all of their workloads on the database being tested in SQL. The following is an example from TPROC-C from SQL Server. TPROC-C however is derived from the TPC-C specification and requires application logic around the SQL. Database interfaces in C. select top 100.

Programming 67

Programming Benchmarking Virtualization C++ 67

Randon ASCII

OCTOBER 4, 2020

CPU power efficiency is strongly tied to how long the CPU can stay asleep ( 8+ ms is apparently a good number ), and random wakeups work against that. If multiple threads can synchronize or coalesce their timer waits then the system becomes more power efficient. It’s fifteen lines of code. That’s crazy! Implications.

Programming 145

Programming Games Hardware Operating System 145

Sutter's Mill

JANUARY 25, 2021

On a humorous note, O(N) remains O(N) no matter how hard we try to make it efficient: MyAssert( std::is_sorted( std::execution::par, begin(s), end(s) ) ); // still O(N) arbitrarily expensive, but good try! What does the answer to Question 1 imply for assertion checking?

C++ 45

C++ Programming Cache Testing 45

SQL Performance

JUNE 10, 2020

That is, does SQL Server perform a substitution process whereby it converts the original nested code into one query that goes directly against the base tables? Recall that a relation’s body—being a set of tuples—by definition has no duplicates. Unnesting/substitution/inlining: Does SQL Server unnest, or inline, the derived table query?

C++ 93

C++ Database Servers Code 93

SQL Performance

MAY 8, 2019

Run the following code to create a helper function called GetNums, and to create and populate the Customers and Orders tables: SET NOCOUNT ON ; USE tempdb ; GO. GetNums ( 1 , 100 ) AS C WHERE C. However, the code uses custid in both the outer and inner queries. Substitution error. DROP TABLE IF EXISTS dbo.

Best Practices 68

Best Practices C++ Code Servers 68

Testsigma

DECEMBER 27, 2019

If your application is compatible enough, it will definitely help in obtaining a good business. Also on the other hand, in spite of having the best of automated testing tools and expertise in coding the automated test scripts, there would be few modules in the application that cannot be automated. But which is better?

Testing 54

Testing Testing Tools Operating System Mobile 54

The Morning Paper

NOVEMBER 7, 2019

The definition of root cause itself is taken from Wilson : “Root cause is that most basic reason for an undesirable condition or problem which, if eliminated or corrected, would have prevented it from existing or occurring.” We evaluated Kairux on 10 randomly sampled real-world failures reported in Hadoop, HBase, and ZooKeeper.

Programming 47

Programming Java C++ Testing 47

SQL Performance

NOVEMBER 13, 2019

Use the following code to create this table and populate it with sample data: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. Here's the definition of the POC that supports our query: CREATE INDEX idx_grp_data_i_id ON dbo. Consider the following UDF definition as an example: DROP FUNCTION IF EXISTS dbo. CREATE TABLE dbo.

Servers 104

Servers C++ Storage Performance 104

KeyCDN

JUNE 25, 2020

vim filename.css The idea behind having a modal text editor is that it allows you to write and edit text, including code, without requiring your hands leave the keyboard. Install Vim using Git: According to Vim themselves, install Vim via Git is the simplest and most efficient method.

Games 125

Games Open Source Availability C++ 125

Nick Desaulniers

MAY 25, 2015

The other programs that might be compiled are C, C++, and to some extent Java and C#. Taking the time to do translation to native machine code ahead of time can result in better performance at runtime, but an interpreter can get to work right away without spending any time translating.

C++ 73

C++ Programming Code Architecture 73

SQL Performance

SEPTEMBER 2, 2021

SQL Server Split String Replacement Code with STRING_SPLIT. If you wish to use CLR, you should definitely borrow code from fellow MVP Adam Machanic before thinking about writing your own (I've blogged before about re-inventing the wheel , and it also applies to free code snippets like this). WHERE Item = c.

C++ 59

C++ Servers Testing Database 59

Randon ASCII

APRIL 17, 2018

When you own all of the code then this may involve some back of the envelope estimates, competitive benchmarking, or intuition tuned by experience. VsChromium is a Visual Studio extension that keeps all of the source code in a monitored directory loaded into RAM. We know that this code is running too slow.

Monitoring 43

Monitoring C++ Code Processing 43

Smashing Magazine

JANUARY 11, 2021

Have we optimized enough with tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, progressive hydration, clients hints, HTTP/3, service workers and — oh my — edge workers? It’s much easier to reach performance goals when the code base is fresh or is just being refactored.

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 7, 2019

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? The first render tends to warm up a bunch of lazily compiled code, which a larger tree can benefit from when it scales.

Performance 103

Performance Cache Metrics Network 103

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? It’s much easier to reach performance goals when the code base is fresh or is just being refactored.

Performance 145

Performance Cache Network Metrics 145

Brendan Gregg

SEPTEMBER 5, 2017

It uses a Solaris Porting Layer (SPL) to provide a Solaris-kernel interface on Linux, so that unmodified ZFS code can execute. There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). Hit Ctrl-C to end. ^C

Virtualization 76

Virtualization AWS Engineering Hardware 76

Smashing Magazine

NOVEMBER 30, 2021

Adding A Dyslexia-Friendly Mode To A Website written by John C Barstow. And so we can definitely dig into that in a bunch of different angles, depending on where you want to take this conversation. Wildcard Subdomains written by Sam Poder. Improving The Performance Of Wix Websites written by Dan Shappir. How To Maintain A Large Next.js

Technology 94

Technology Technology Servers Code 94

Smashing Magazine

AUGUST 9, 2021

QUIC is needed because TCP, which has been around since the early days of the Internet, was not really built with maximum efficiency in mind. For example, if we have files A, B, and C, we would have three TCP connections. 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,

Transportation 145

Transportation Internet Internet Network 145

Smashing Magazine

AUGUST 22, 2021

While a perfect understanding of these concepts is not needed for the rest of this post, having a common high-level definition would be good. One aspect of performance is about how efficiently a transport protocol can use a network’s full (physical) bandwidth (i.e. Congestion Control. Large preview ). Large preview ).

Performance 105

Performance Network Latency Servers 105

Strategic Tech

JUNE 23, 2018

Whenever a team starts on a piece of work they should own all of the code and infrastructure that needs to change in order to deliver the work. I’ve seen a number of systems where the thinking was “our monoliths are so big we’re going to put all new code in a new codebase”. The costs of a bad decision are non-trivial.

Systems 40

Systems Social Media Design Media 40

The Netflix TechBlog

SEPTEMBER 10, 2019

In order to replicate results, scientists had to delve deep into the data, code, and documentation. We’ve also made sure that both production and local workflows use the same code base, so reproducibility is a given and promotion to production is just a pull request away.

Metrics 215

Metrics Architecture Infrastructure Innovation 215

High Scalability

NOVEMBER 25, 2019

Java used to power core file system code. Python used to power client-side code, certain microservices, migration scripts, internal scripts. Version7 (Future): Move all compute to the public cloud, carve out more services for impact isolation, dynamic resource pooling to manage pets and cattle efficiently. Data interdependence.

Architecture 52

Architecture Cache Azure Storage 52