Nonclustered columnstore indexes
After all of the theoretical introduction, it is time to start using the columnar storage. You will start by learning how to create and use nonclustered columnstore indexes (NCCI). You already know from the previous section that a NCCI can be filtered. Now you will learn how to create, use, and ignore a NCCI. In addition, you will measure the compression rate of the columnar storage.
Because of the different burdens on SQL Server when a transactional application uses it compared to analytical applications usage, traditionally, companies split these applications and created data warehouses. Analytical queries are diverted to the data warehouse database. This means that you have a copy of data in your data warehouse, of course with a different schema. You also need to implement the Extract Transform Load (ETL) process for scheduled loading of the data warehouse. This means that the data you analyze is somehow stall. Frequently, the data is loaded overnight...
