Aaron Bertrand (@AaronBertrand) walks through a solution that allows you to achieve some of the benefits of partitioning without the Enterprise Edition price tag.
Erin Stellato (@erinstellato) of SQLskills demonstrates that, while incremental statistics can help with maintenance, they are ignored by the optimizer.
Erin Stellato (@erinstellato) of SQLskills discusses partitioning and explains how it is not always a magic turbo button for improving query performance.
Erin Stellato (@erinstellato) talks about the implications of holding onto data, beyond its reasonable lifetime, in monolithic, single-partition tables.
Paul White (@SQL_kiwi) talks about a regression in the optimizer's handling of aggregates against partitioned tables when moving from SQL Server 2005 to SQL Server 2008+.