Table partitioning is a fantastic tool to help you manage tables with skyrocketing rowcounts. SQL Server 2016 SP1 made table partitioning available in Standard Edition, so you may be planning to add partitioning to your database.
But 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.
This course teaches you to use execution plans to troubleshoot regressed queries using partitioned tables. You will learn what “non-aligned” indexes are, how to tell how many partitions a query is really using, and see options for TSQL and indexing changes to speed up your queries.
- Course goals and demo data (6 minutes)
- Problem Query: The Aggregator (34 minutes)
- Problem Query: Max / Min (24 minutes)
- Problem Query: Unexpectedly Blocked (9 minutes)
- Interview questions and answers (10 minutes)
- Pull it all together (4 minutes)
Each lesson is 16 minutes or less, so you can easily fit in a lesson today and pick up where you left off tomorrow.
Not ready to commit? Check out the course outline and preview three videos in the course.