Design decisions and coding techniques for SQL Data Warehouse
Take a look through these development articles to better understand key design decisions, recommendations, and coding techniques for SQL Data Warehouse.
Key design decisions
The following articles highlight concepts and design decisions for developing a distributed data warehouse using SQL Data Warehouse:
- user-defined schemas
- table distribution
- table indexes
- table partitions
Development recommendations and coding techniques
These articles highlight specific coding techniques, tips, and recommendations for developing your SQL Data Warehouse:
- stored procedures
- temporary tables
- dynamic SQL
- group by options
- variable assignment
For more reference information, see the Transact-SQL reference page for SQL Data Warehouse.