Blog: SQL performance (sqlsentry)

210 blogs updated: 25 min. ago
Optimization Thresholds – Grouping and Aggregating Data, Part 1
In his first SQLPerformance post, Itzik Ben-Gan shows you how to reverse engineer optimizer costing for a Stream Aggregate operator. The pos...
11-04-2018 15:51:17 SQL performance (sqlsentry) SQL Server
Automatic Index Management in Azure SQL Database
Following up on her previous post about automatic plan correction, Erin Stellato talks about a new self-tuning feature in Azure SQL Database...
05-04-2018 16:47:16 SQL performance (sqlsentry) SQL Server
Dealing with date and time instead of datetime
Rob Farley describes a tactic where adding multiple predicates around separate date and time columns can win you some better performance. Th...
29-03-2018 15:18:19 SQL performance (sqlsentry) SQL Server
Row Goals, Part 4: The Anti Join Anti Pattern
Paul White continues his series on row goals, treating a redundant and problematic TOP (1) that is added to the inner side of an apply anti ...
19-03-2018 14:31:57 SQL performance (sqlsentry) SQL Server
Usually DISTINCT and GROUP BY will yield the same results, but here Rob Farley explains cases that can break the rule. The post When DISTINC...
13-03-2018 15:35:13 SQL performance (sqlsentry) SQL Server
Row Goals, Part 3: Anti Joins
Continuing his in-depth series on row goals, Paul White explains both why and how they can impact queries involving anti joins. The post Row...
07-03-2018 18:38:33 SQL performance (sqlsentry) SQL Server
SQL Server and the Spectre/Meltdown Vulnerabilities
Glenn Berry explains how the Spectre/Meltdown issues (and their patches!) may affect SQL Server performance, and provides a handy list of mi...
01-03-2018 14:42:52 SQL performance (sqlsentry) SQL Server
Row Goals Part 2: Semi Joins
It is relatively well-known that using TOP or a FAST n query hint can set a row goal in an execution plan (see Setting and Identifying Row G...
22-02-2018 16:28:45 SQL performance (sqlsentry) SQL Server
Automatic Plan Correction in SQL Server
Erin Stellato gives an overview of Automatic Plan Correction in SQL Server 2017 and Azure SQL Database, and assures us that Microsoft is not...
19-02-2018 14:27:13 SQL performance (sqlsentry) SQL Server
Setting and Identifying Row Goals in Execution Plans
Paul White provides some great information about row goals, explaining why they're important to understand when examining why the query opti...
12-02-2018 13:53:37 SQL performance (sqlsentry) SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.