Partitioned Tables Cause Longer Plan Compilation Times

Folks sometimes ask, “When a table has more indexes, and SQL Server has more decisions to make, does that slow down execution plan generation?”. Brent Ozar talks through his response in this article.

Introduction to the Partition By Window Function

Window functions can be life savers by making a complicated SQL calculation easy. A window function combines that logic and provides row by row or window by window feedback. Read on to learn more!

Introduction to the Partition By Window Function

Window functions can be life savers by making a complicated SQL calculation easy. A window function combines that logic and provides row by row or window by window feedback. Read on to learn more!

Partitioning Data in SQL Server without using Partitioned Tables

In this we look at how we to quickly split up data from a SQL Server table into relatively equal size buckets.

Partition Level Locking: Explanations From Outer Space

Erik Darling partitions the Stack Overflow database, then uses sp_WhoIsActive's @get_locks = 1 parameter to demo locking.

Loading partitioned table incrementally using SSIS

This article gives an example of loading partitioned tables incrementally using SSIS

Partition elimination and variables

Changes to a Writable Partition May Fail Unexpectedly

Paul White shows how an update may fail when a partition has some data on a read-only filegroup, and explains several workarounds.

Partitioning on a Budget

Enterprise Edition customers enjoy the manageability and performance benefits offered by table partitioning, but this feature is not available in Standard Edition. Aaron Bertrand explains his idea for achieving at least some of partitioning's upsides on any edition.

A Tale of Partition Schemes and Disappearing Dragons

A tale in which is detailed how I used SWITCH PARTITION to efficiently load my data and save myself from the flaming jaws of death.