“Let me once again explain the rules.The Azure SQL Data Warehouse Rules!”
- Tera-Tom Coffing
1.Tables are either Distributed by Hash or Replicated
2.The rows of a table are either sorted or unsorted
3.Tables are stored physically on disk in either a row or columnar Format
4.Tables can be partitioned
5.Tables are either permanent, temporary or external Tables
Above, are some basics about concepts for Azure SQL Data Warehouse tables. The next five pages will cover each point one at a time. This will allow you to see exactly what is going on immediately.
The Azure SQL Data Warehouse ...