官术网_书友最值得收藏!

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.

主站蜘蛛池模板: 江永县| 西青区| 景谷| 青阳县| 雷波县| 惠东县| 寻甸| 蒙阴县| 呼图壁县| 闽清县| 新乡市| 当雄县| 沁源县| 漳州市| 寿宁县| 涡阳县| 方山县| 敖汉旗| 澜沧| 徐州市| 郑州市| 武夷山市| 体育| 沙湾县| 曲水县| 孟津县| 驻马店市| 邹平县| 磐安县| 咸阳市| 沐川县| 霍邱县| 台江县| 南京市| 杭锦后旗| 博客| 桐梓县| 罗山县| 侯马市| 神农架林区| 容城县|