Aaron Bertrand (@AaronBertrand) walks through a solution that allows you to achieve some of the benefits of partitioning without the Enterprise Edition price tag.
Dan Holmes (sql.dnhlms.com) talks about a solution he developed to manually coerce statistics to be more accurate and produce better, more predictable execution plans.
Erin Stellato (@erinstellato) of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.
Aaron Bertrand (@AaronBertrand) shows some interesting maintenance opportunities for Service Broker queues available in the next version of SQL Server.
