Blog: SQL performance (sqlsentry)


210 blogs updated: 44 min. ago
Join Elimination: When SQL Server Removes Unnecessary Tables
For his first guest post on SQLPerformance.com, Bert Wagner describes the pros and cons of join elimination in SQL Server. The post Join Eli...
0
18-06-2018 13:51:13 SQL performance (sqlsentry) SQL Server
Optimization Thresholds - Grouping and Aggregating Data, Part 3
Itzik Ben-Gan dissects the Hash Match (Aggregate) algorithm in his latest post in a series on SQL Server optimization thresholds. The post O...
3
13-06-2018 11:58:13 SQL performance (sqlsentry) SQL Server
The Importance of Baselines
Tim Radney goes into detail about why baselines are important, and how metrics you collect now can help you solve future problems. The post ...
3
24-05-2018 15:35:21 SQL performance (sqlsentry) SQL Server
Optimization Thresholds - Grouping and Aggregating Data, Part 2
Continuing his series on optimization thresholds, Itzik Ben-Gan dives into the calculations behind stream aggregate costing when the data ne...
0
09-05-2018 14:11:43 SQL performance (sqlsentry) SQL Server
Reasons to Upgrade to SQL Server 2017
Glenn Berry discusses a number of compelling reasons why, if you are choosing between SQL Server 2016 or SQL Server 2017, you should choose ...
16
23-04-2018 15:02:06 SQL performance (sqlsentry) SQL Server
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...
15
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...
12
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...
4
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 ...
12
19-03-2018 14:31:57 SQL performance (sqlsentry) SQL Server
When DISTINCT <> GROUP BY
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...
9
13-03-2018 15:35:13 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.