The challenge is on! Community call for creating the fastest number series generator
SQL Performance
DECEMBER 9, 2020
L0 AS ( SELECT 1 AS c. Figure 1: Plan for base CTE cardinality of 2.
SQL Performance
DECEMBER 9, 2020
L0 AS ( SELECT 1 AS c. Figure 1: Plan for base CTE cardinality of 2.
Brendan Gregg
OCTOBER 8, 2018
C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. ply is also C, whereas bpftrace is C++. # Attaching 2 probes. ^C
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Performance
OCTOBER 29, 2019
There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). CustomerID , c. Customers c JOIN Sales. CustomerTransactions ct ON c. GROUP BY c. CustomerID , c. Each option has pros and cons. CustomerID = ct.
Percona
JANUARY 17, 2019
I will compare AWS Aurora with MySQL (Percona Server) 5.6 84.1 | | version_comment | Percona Server (GPL), Release 84.1, 84.1 | | version_comment | Percona Server (GPL), Release 84.1, AWS Aurora (based on MySQL 5.6) MySQL on ec2. MySQL on ec2.
SQL Performance
DECEMBER 9, 2020
L0 AS ( SELECT 1 AS c. Figure 1: Plan for base CTE cardinality of 2.
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().
Rigor
JANUARY 13, 2020
These are the bestsellers in the web performance field, including the good old Speed Up Your Site (2003) by Andy King; Steve Souders’ Even Faster Web Sites (2009) ; Ilya Grigorik’s High Performance Browser Networking (2013) ; Tammy Everts’ Time is Money (2016) ; and a handful of more recent publications. Responsive and Fast.
Let's personalize your content