Nonclustered columnstore indexes
After a theoretical introduction, it is time to start using columnar storage. You will start by learning how to create and use NCCI. You already know from the previous section that an NCCI can be filtered. Now you will learn how to create, use, and ignore an 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 ETLÂ process for scheduled loading of the data warehouse. This means that the data you analyze is somehow stalled. Frequently, the data is loaded overnight and is thus one day old when you analyze it. For many analytical purposes...