SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. In Part 4 of the series, which focused on optimization of derived tables, I described a process of unnesting/substitution of table expressions. You can find the script that creates and populates TSQLV5 here , and its ER diagram here.

C++ 52

C++ Servers Code Efficiency 52

SQL Performance

JUNE 9, 2021

That is, ones that are created as an object in the database, and stay there permanently unless dropped. In my examples I’ll use a sample database called TSQLV5. A table could be a base table defined as an object in the database, or it could be a table returned by an expression—more specifically, a table expression.

Database 140

Database Code Design Development 140

Percona

JANUARY 24, 2023

Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. Such “torn pages” are corruptions from the database point of view. Individual processes generate WAL records, and latency is very crucial for transactions.

Database 115

Database Benchmarking Open Source Latency 115

SQL Performance

DECEMBER 9, 2020

I mainly experimented with different table value constructor cardinalities, with serial versus parallel processing, and with row mode versus batch mode processing. You can create supporting tables in the user database if needed. The plan is serial, and all operators in the plan use row mode processing by default.

C++ 114

C++ Servers Testing Processing 114

Adrian Cockcroft

JANUARY 29, 2023

I presented this analysis of response time distributions talk in 2016 — at Microxchg in Berlin ( video ). The code is written using the R statistics language and I downloaded a free copy of RStudio to run the examples below. > For high traffic systems, processing the individual response times for each request may be too much work.

Lambda 98

Lambda Latency Cache C++ 98

Adrian Cockcroft

JANUARY 31, 2023

I’d helped eBay recover from capacity related outages in 1999 and had setup their capacity planning processes. I remember telling Eric “I just wrote 1000 lines of code in a language no-one’s really used in 25 years to build this actor based simulator, and it works!”

Google 52

Google Transportation Programming Innovation 52

SQL Performance

AUGUST 14, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Run the following code to create the Transactions table and populate it with sample data: SET NOCOUNT ON ; USE TSQLV5 ; -- [link]. DROP TABLE IF EXISTS dbo. Transactions. (

Best Practices 108

Best Practices Servers Database Azure 108

Percona

JUNE 4, 2023

Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. It is largely an unofficial response to published comments from the MariaDB Corporation. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

SQL Performance

DECEMBER 9, 2020

I mainly experimented with different table value constructor cardinalities, with serial versus parallel processing, and with row mode versus batch mode processing. You can create supporting tables in the user database if needed. The plan is serial, and all operators in the plan use row mode processing by default.

C++ 61

C++ Servers Testing Processing 61

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. That is to ensure your database is encrypted at the file level. The process to enable this for a database is described in our documentation. What does encrypted mean at this point?

Servers 40

Servers Database Azure Cache 40

Particular Software

OCTOBER 3, 2017

This article was originally published on the NDC 2016 Blog. Code that had duplication all over the place? Chances are you were dealing with legacy code that was written years ago. In my 15+ years of coding, every single time I've dealt with legacy code, fear, anger, hate, and suffering were pretty common.

Architecture 49

Architecture Database Code Systems 49

SQL Server According to Bob

APRIL 25, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. 10 percent processed.

Servers 40

Servers Database Processing Virtualization 40

SQL Server According to Bob

APRIL 21, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. 10 percent processed.

Servers 40

Servers Database Processing Virtualization 40

SQL Performance

SEPTEMBER 2, 2021

A lot of things change over the course of a few major versions of our favorite database platform. SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1. It’s fast, too, but it’s not perfect.

C++ 59

C++ Servers Testing Database 59

SQL Performance

JULY 9, 2019

The ISO/IEC 9075:2016 standard (SQL:2016) defines a feature called nested window functions. For example, suppose that you want to query the Sales.OrderValues view in the TSQLV5 sample database, and return for each customer and order date, the daily total of the order values, and the running total until the current day.

Servers 83

Servers Availability Database Code 83

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. For the more adventurous/technical, the top (table of processes) command provides similar metrics on most Unix-like operating systems such as macOS and Ubuntu.

Website Performance 73

Website Performance Website Energy Performance 73

Alex Russell

MAY 9, 2022

Effective managers understand that products require processes to manage, yet front-end discourse assumes that switching frameworks will introduce a golden age. Who owns this code? When sibling teams are brought in to integrate late in the process, attention to the cumulative experience may suffer. Why is it there?

Performance 86

Performance Latency Metrics Engineering 86

The Symphonia

DECEMBER 6, 2017

Specific improvements include A new code editor for those who write their Lambda functions in Javascript and Python, far superior to the old inline code-editor. We don’t recommend using this as a regular process for production use, but it might come in handy at development time. Also allows for creating new files in line.

Serverless 40

Serverless Lambda AWS Traffic 40

SQL Performance

APRIL 23, 2019

This eliminated unnecessary row-mode processing, and removed the need for an exchange. SQL Server 2016 introduced serial batch mode processing and aggregate pushdown. Still, when the plan generally qualifies for grouped aggregate pushdown, both pushdown (fast) and non-pushdown (slow) code paths are made available.

Servers 67

Servers Testing Metrics Storage 67

SQL Server According to Bob

FEBRUARY 10, 2019

This means we are reading database pages from the master, acquiring locks, and making calls to the domain controller (DC/KDC.). The lack of wait_info* events is revealing because if we are waiting for a database read, lock or preemptive, external call for more than 5 seconds an event would have been logged. wait_info*. Network Trace.

Servers 40

Servers Network Database Systems 40

Smashing Magazine

OCTOBER 26, 2018

Because of its history and for being sort of a fork of an old blogging platform called “b2” (more details here ), it’s largely written in a procedural way (using function-based code). Recommended reading : WordPress Security As A Process. Before we delve deeper in the code, a couple more things about WordPress REST API.

Cache 78

Cache Website Speed Database 78

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Microsoft SQL Server Database Engine Input/Output Requirements. Red Hat, SUSE, HPE, Intel helping and confirming Linux behaviors and making file system code changes. The Back Story.

Servers 90

Servers Media Cache Storage 90

Alex Russell

APRIL 29, 2021

After 20 years of neck-in-neck competition, often starting from common code lineages, there just isn't that much left to wring out of the system. At the time of the last Confluence run, the gap had stretched to nearly 1000 APIs, doubling since 2016. Helps media apps on the web save battery when doing video processing.

Media 145

Media Games Education Engineering 145

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. The import process establishes communication between MSTDC (B) and MSDTC (A), creating the proper superior to subordinate relationship, adding DTC voting endpoints and returning an ITransaction to SQL Server. Microsoft specific implementation for DTC using (OLE-TX).

Servers 40

Servers Azure Engineering Java 40