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

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
How to Trace Trigger Executions with Query Store and Extended Events

How to Trace Trigger Executions with Query Store and Extended Events

Triggers can be tricky to observe in SQL Server. When you need to understand exactly what a trigger is doing and what it impacts, Query Store and …

Read More
How to Filter RPC_Completed Events in Extended Events: SQL Server Guide

How to Filter RPC_Completed Events in Extended Events: SQL Server Guide

The rpc_completed event in Extended Events is useful when troubleshooting SQL Server performance. It captures detailed information about Remote …

Read More