The effects of column level compression

The Azure SQL Data Warehouse service is built on SQL Server and extends the capabilities of SQL Server for large scale relational data warehouse workloads. One of the areas of interest is how to you optimize for databases with terabytes or petabytes of data. One answer is Clustered Columnar indexes (CCI). A columnar index is…


Exporting to a single file in SQL Data Warehouse

Azure SQL Data Warehouse includes PolyBase – a technology that accesses and combines both non-relational and relational data from T-SQL . It allows you to run queries on external data in Azure blob storage and can be used for importing or exporting data. External data is exposed through a concept called an external table (see…