Query Optimizer Deep Dive (AD)

preview_player
Показать описание
Paul White, SQL Kiwi Limited
  1. PASS Data Community Summit
  2. PASS
  3. SQLPASS
  4. SQL
  5. SQL Server
  6. Database
Рекомендации по теме
Query Optimizer Deep 2:34:56

Query Optimizer Deep Dive (AD)

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Stop Slow Queries! 0:00:06

Stop Slow Queries! Master SQL Optimization in 10 Easy Steps

Session 1: SQL 0:15:55

Session 1: SQL Server Optimizer: deeper dive!

NWDS Talk - 1:05:46

NWDS Talk - CockroachDB's Query Optimizer

Join Order by 0:07:22

Join Order by SQL Server Query Optimizer

Master the Polars 0:09:24

Master the Polars Query Optimizer in Minutes with Lazy Evaluation!

Explaining the Postgres 0:29:04

Explaining the Postgres Query Optimizer | Citus Con: An Event for Postgres 2022

SQL Server for 0:19:05

SQL Server for Beginners - How Does the Query Optimizer Work?!?

A Deep Dive 1:06:14

A Deep Dive into Execution Plans & How to Use Them! - Janis Griffin

The Future of 0:43:34

The Future of Presto's Query Optimizer - Bill McKenna, Ahana

SQL Server Query 0:31:36

SQL Server Query Optimizer – Lesser Known Things

A Deep Dive 0:23:10

A Deep Dive into the Catalyst Optimizer Hands on Lab (Herman van Hovell)

Inside the SQL 0:59:29

Inside the SQL Server Query Optimizer

SQL Server Query 0:00:21

SQL Server Query Tuning Series - SQL Server Query Tuning: Optimizing Stored Procedure Estimations

Webinar: Explaining the 0:57:35

Webinar: Explaining the Postgres Query Optimizer

The SQL Server 1:02:28

The SQL Server 2014 Query Optimizer

Job Progress Optimization: 0:51:34

Job Progress Optimization: Deep Dive into Connections, Improvements & Query Analysis | 2023 Guid...

Presto query optimizer: 0:59:53

Presto query optimizer: pursuit of performance

Update Queries-Deep Dive 1:03:37

Update Queries-Deep Dive

Torsten Strauß - 1:01:05

Torsten Strauß - Query Optimizer

The SQL Engine 0:01:17

The SQL Engine - Mastering SQL Server Query Optimization

Query Analysis Deep 1:14:51

Query Analysis Deep Dive: 13 Causes of a Slow Query - Fabiano Amorim

Optimize Your SQL 0:22:52

Optimize Your SQL Queries | Postgres Edition

Комментарии
Автор

Hi Paul, a follow up to your question in this video regarding Sum() on an empty set returning null and not 0... This also happens in C# programming but only for a list that you can query (known as an IQueryable). The sum of an empty IQueryable returns null. However, C# also has whats known as IEnumerable which is a list that you can enumerate over. The sum of an empty IEnumerable returns 0 which is what you'd expect. I'm sure the MS gods had some good reason to return null when the set is empty ;)

nicholassmith