Azure Synapse Analytics 中专用 SQL 池(之前称为 SQL DW)的设计决策和编码技术Design decisions and coding techniques for a dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics
在本文中,你将找到更多资源,帮助你更好地理解 Azure Synapse 中专用 SQL 池(之前称为 SQL DW)的关键设计决策、建议和编码技术。In this article, you'll find additional resources to help you better understand key design decisions, recommendations, and coding techniques for a dedicated SQL pool (formerly SQL DW) in Azure Synapse.
关键设计决策Key design decisions
以下文章重点介绍了使用 Azure Synapse 中的专用 SQL 池(之前称为 SQL DW)功能开发分布式数据仓库的概念和设计决策:The following articles highlight concepts and design decisions for developing a distributed data warehouse using the dedicated SQL pool (formerly SQL DW) capability in Azure Synapse:
- 连接connections
- 并发concurrency
- 事务transactions
- 用户定义的架构user-defined schemas
- 表分布table distribution
- 表索引table indexes
- 表分区table partitions
- CTASCTAS
- 统计信息statistics
开发建议和编程技术Development recommendations and coding techniques
以下文章介绍了开发专用 SQL 池(之前称为 SQL DW)的特定编码技术、技巧和建议:The following articles feature specific coding techniques, tips, and recommendations for developing a dedicated SQL pool (formerly SQL DW):
- 存储过程stored procedures
- 标签labels
- 视图views
- 临时表temporary tables
- 动态 SQLdynamic SQL
- 循环looping
- group by 选项group by options
- 变量赋值variable assignment
后续步骤Next steps
有关更多参考信息,请参阅 T-SQL 语句。For more reference information, see T-SQL statements.