- Learn T-SQL Querying
- Pedro Lopes Pam Lahoud
- 120字
- 2021-06-24 14:38:11
Summary
To understand how to write solid, performant T-SQL, users should become familiar with how SQL Server runs T-SQL syntax to deliver the intended result sets in a scalable fashion. In this chapter, we covered the basic building blocks that make up a T-SQL statement, as well as how SQL Server interprets those blocks to begin the process of executing the user's query. The concepts introduced in this chapter will be used throughout the remaining sections of the book to explain most patterns and anti-patterns, as well as mitigation strategies.
In the next chapter, we will build on our knowledge of how SQL Server processes T-SQL statements to understand how the Query Processor optimizes, caches, and ultimately executes the query.
推薦閱讀
- 大數(shù)據(jù)技術(shù)與應(yīng)用基礎(chǔ)
- 電力自動(dòng)化實(shí)用技術(shù)問(wèn)答
- Mastering Matplotlib 2.x
- Maya 2012從入門(mén)到精通
- Docker Quick Start Guide
- Apache Spark Deep Learning Cookbook
- JSF2和RichFaces4使用指南
- 精通特征工程
- 現(xiàn)代傳感技術(shù)
- Implementing Oracle API Platform Cloud Service
- 項(xiàng)目管理成功利器Project 2007全程解析
- 與人共融機(jī)器人的關(guān)節(jié)力矩測(cè)量技術(shù)
- Deep Learning Essentials
- Getting Started with Tableau 2018.x
- ARM體系結(jié)構(gòu)與編程