Did that Query Eliminate Partitions? (videos)

Did that Query Eliminate Partitions? (videos)

By Kendra Little
1 min read
Category: query-performance
Tags: partitioning , execution-plans , partition-elimination
Did that Query Eliminate Partitions? (videos) 1 min read
Did that Query Eliminate Partitions? (videos)

Table partitioning makes execution plans a bit more confusing.

Free Course

I have a free online course which walks you through decoding execution plans, including whether or not partition elimination occurred.

RELATED POSTS

Adaptive Joins and Memory Grants in SQL Server

Adaptive Joins and Memory Grants in SQL Server

Adaptive joins let the optimizer choose between a Hash Join and a Nested Loop join at runtime, which can be fantastic for performance when row count …

Read More
Carrying Baggage Through Query Plans: Why Wide Queries Get Heavy

Carrying Baggage Through Query Plans: Why Wide Queries Get Heavy

I see this pattern repeatedly: a “wide” query that returns many columns and less than 100k rows runs slowly. SQL Server gets slow when it …

Read More
Testing SQL Server 2025 Resource Governor tempdb Limits with a Query that Spills a Terabyte

Testing SQL Server 2025 Resource Governor tempdb Limits with a Query that Spills a Terabyte

SQL Server 2025 introduces a new Resource Governor capability to manage tempdb usage, along with making Resource Governor available in Standard …

Read More