Wednesday, October 2 • 11:30am - 12:30pm
Columnstore Indexes – Practical Solutions & Techniques

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Learn practical Columnstore Indexes tips and tricks such as which type to use, how and when to use Disk-Based vs. In-Memory or Clustered vs. Nonclustered, how to load data into Columnstore in the most efficient way, and how to get the best performance possible out of the Batch Execution Mode. With a nod to each of the available SQL Server versions (2012, 2014, 2016, 2017, 2019 and the Azure SQLDB), this full day session focuses on practical solutions and applications of Columnstore Indexes and the Batch Execution Mode. We also review the limitations of both and learn how to solve some of those limitations. Covering all available relational engines supporting Columnstore Indexes (including parts of the SQL DataWarehouse), this pre-conference will give you insight on why and when to use Columnstore Indexes, and when to take a step back and use a different type of technology. Since November 2016 (and more specifically since Service Pack 1 for SQL Server 2016), Columnstore Indexes have been available for every Edition of SQL Server (including Express and Local editions). Join this workshop and become a part of the columnar revolution that is positively affecting database platforms around the world.

avatar for Niko Neugebauer

Niko Neugebauer

Niko Neugebauer is a Data Platform specialist. A SQL Server MVP with over 20 years of experience in IT, he is passionate about Data Platform and Community. Founder of the Portuguese SQL Server User Group, the main organizer of the first SQLSaturday outside of North America – #78... Read More →

Wednesday October 2, 2019 11:30am - 12:30pm CEST
Room 1