Why Table Partitioning Does Not Speed Up Query Performance - With One Exception (52 minutes)Learn why SQL Server’s table partitioning feature won’t make your queries against disk-based rowstore indexes faster– and may even make them slower. |
|
Execution Plans: Partitioned Tables and Columnstore Indexes (1 hour 30 minutes)Execution plans are incredibly helpful when it comes to tuning queries using partitioned indexes and columnstore indexes – but when you look closely, you’ll notice that some things are very weird! |
|
Problem Queries in Table Partitioning (1 hour 30 minutes)Some queries may get slower after you partition your tables: the SQL Server optimizer doesn’t always use indexes the same way after those indexes are partitioned into chunks. |