Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.
on March 2, 2017
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.