New Course: Tuning Problem Queries in Table Partitioning

As of SQL Server 2016 SP1, you can now use partitioning in Standard, Web, and even Express Edition of SQL Server.

Everything’s gonna be fast! Right?

Well, not quite. But no worries, this course is now free.

Learn to identify regressed queries against partitioned tables

My new course shows you patterns that slow down when you partition your tables, and gives you options to speed up your queries using index and TSQL changes.

You’ll also learn to use query 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 why the optimizer sees partitioned indexes differently.

You’ll also see a lot of dinosaur drawings.

Bonus: there’s a little columnstore in there, too

Partitioning can pair delightfully with columnstore indexes, so the demos in the course feature a nonclustered columnstore index as our guest star. You’ll get a peek at performance comparisons for this index between Enterprise and Standard Edition, too.

Dive in!

This course is now freely available for everyone.