Columnstore overview

- [Instructor] There should be no question…as to whether or not you use Columnstore indexes…in your data warehouse design, especially…now that they are available on all editions of SQL server.…Prior to SQL Server 2016 SP1, this was…an Enterprise edition only feature.…You'll see big performance gains…on both the read and bulk load side,…and you want to do this on your larger tables,…so, think your fact tables, so things like sales,…and your dimensions that are larger than five million rows.…The only place you would really want to think twice…around this Columnstore design pattern…is on tables that are frequently inserted,…updated, or deleted with singleton processing,…so if you're inserting, updating,…or deleting single records at a time,…you're going to not see as much benefit, and you're going to…see a lot of overhead from those operations.…

So, really, on your warehouse side,…you'll want to focus on these bulk loads.…Let's jump into a demo to see this technology in action.…Okay, for our first example, starting on line four, we're…