SQL Performance

JULY 9, 2019

The ISO/IEC 9075:2016 standard (SQL:2016) defines a feature called nested window functions. I posted a suggestion to improve SQL Server by adding support for nested window functions. At the date of this writing, there's not much information available out there about the true standard nested window functions.

Servers 83

Servers Availability Database Code 83

SQL Performance

AUGUST 11, 2021

For example, the measurements could be temperature and humidity readings taken every 5 minutes, and you want to group the data using hourly buckets and compute aggregates like average per hour. For example, you might want to organize sales data in fiscal year buckets and compute aggregates like the total sales value per fiscal year.

Azure 139

Azure Code Database Servers 139

SQL Performance

AUGUST 14, 2019

Previously I covered determinism , subqueries and joins. SQL Server 2016 introduces the batch-mode Window Aggregate operator, which removes the performance penalty part of the pitfall, but prior to SQL Server 2019 this operator is used only if you have a columnstore index present on the data. Window frame with implicit RANGE option.

Best Practices 108

Best Practices Servers Database Azure 108

Percona

JANUARY 17, 2019

In all versions of MySQL – at least at the time of writing – when you run a single query it will run in one thread, effectively utilizing one CPU core only. I will compare AWS Aurora with MySQL (Percona Server) 5.6 I will compare AWS Aurora with MySQL (Percona Server) 5.6 AWS Aurora (based on MySQL 5.6) Test data and versions.

Cache 46

Cache C++ AWS Airlines 46