Percona

JULY 19, 2023

How would you integrate some new fancy processing library into MySQL without having to recreate the complexities in pure SQL? MySQL Loadable Functions would be the way to go. In this blog post, you’ll learn how to set up a build environment for compiling your own MySQL plugin to be loaded into MySQL as a function.

C++ 79

C++ Servers Benchmarking Best Practices 79

SQL Performance

MARCH 10, 2021

In Part 2 I covered solutions that query a physical base table that you prepopulate with rows. You can read about the fundamentals of column elimination logic with table expressions in Fundamentals of table expressions, Part 3 – Derived tables, optimization considerations under “Column projection and a word on SELECT *.”.

C++ 134

C++ Testing Code Servers 134

SQL Performance

JUNE 10, 2020

In Part 1 and Part 2 of this series, I covered the logical, or conceptual, aspects of named table expressions in general, and derived tables specifically. This month and the next I’m going to cover the physical processing aspects of derived tables. Does it get persisted on disk, and how does SQL Server handle memory for it?

C++ 93

C++ Database Servers Code 93

SQL Performance

AUGUST 12, 2020

This article is the fifth part in a series about table expressions. In Part 1 I provided the background to table expressions. In Part 2 , Part 3 , and Part 4 , I covered both the logical and the optimization aspects of derived tables. This month I start the coverage of common table expressions (CTEs).

C++ 140

C++ Code Design Database 140

SQL Performance

JANUARY 13, 2021

This month I’ll focus primarily on Charlie’s and Alan Burstein’s suggested improvements to the two original solutions that I posted last month in the form of the inline TVFs called dbo.GetNumsItzikBatch and dbo.GetNumsItzik. A CTE called Nums uses the ROW_NUMBER function to produce a series of numbers starting with 1.

C++ 113

C++ Code Testing Processing 113

SQL Performance

NOVEMBER 13, 2019

The ROW_NUMBER window function has numerous practical applications, well beyond just the obvious ranking needs. Most of the time, when you compute row numbers, you need to compute them based on some order, and you provide the desired ordering specification in the function's window order clause. CREATE TABLE dbo.

Servers 104

Servers C++ Storage Performance 104

SQL Performance

APRIL 14, 2021

In Part 1 I covered the function dbo.GetNumsAlanCharlieItzikBatch, which combined ideas from Alan, Charlie and myself. Here’s the function’s definition: -- Helper dummy table. DROP TABLE IF EXISTS dbo. CREATE TABLE dbo. CREATE OR ALTER FUNCTION dbo. CREATE OR ALTER FUNCTION dbo. BatchMe ; GO.

C++ 112

C++ Servers Testing Code 112

SQL Performance

DECEMBER 9, 2020

In Part 5 of my series on table expressions I provided the following solution for generating a series of numbers using CTEs, a table value constructor and cross joins: DECLARE @low AS BIGINT = 1001 , @high AS BIGINT = 1010 ; WITH. Testing different base table cardinalities is just one dimension to try.

C++ 114

C++ Servers Testing Processing 114

SQL Performance

JUNE 9, 2021

This is the 9th part in a series about named table expressions. In Part 1 I provided the background to named table expressions, which include derived tables, common table expressions (CTEs), views and inline table valued functions (iTVFs). A table expression could be a query.

Database 140

Database Code Design Development 140

SQL Performance

AUGUST 23, 2019

In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join. There have been major improvements since the first appearance of the batch mode execution engine in SQL Server 2012. Background. The Query Optimizer.

Servers 75

Servers Engineering Efficiency Retail 75

SQL Performance

DECEMBER 3, 2019

Take the following example, where we have a sales database containing a table of orders. represent a smaller and smaller percentage of the overall table: CREATE DATABASE Sales ; GO. USE Sales ; GO. -- simplified, obviously: CREATE TABLE dbo. Dynamic SQL? CREATE FUNCTION dbo. GetUnshippedOrders. CREATE VIEW dbo.

Database 81

Database Efficiency Cache Code 81

SQL Performance

SEPTEMBER 2, 2021

SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT().

C++ 59

C++ Servers Testing Database 59

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server.

IoT 61

IoT Servers Development Cache 61

SQL Performance

DECEMBER 9, 2020

In Part 5 of my series on table expressions I provided the following solution for generating a series of numbers using CTEs, a table value constructor and cross joins: DECLARE @low AS BIGINT = 1001 , @high AS BIGINT = 1010 ; WITH. Testing different base table cardinalities is just one dimension to try.

C++ 61

C++ Servers Testing Processing 61

The Symphonia

DECEMBER 6, 2017

the Functions-as-a-Service (FaaS) platform which is the core of AWS’ larger Serverless service suite. One of the most significant announcements of the entire conference to me was that of per-function concurrency control. Lambda functions can now be configured to have 3GB RAM , up from 1.5GB. Let’s dig in!

Serverless 40

Serverless Lambda AWS Traffic 40