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 ...
