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

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.

主站蜘蛛池模板: 安国市| 崇义县| 沈阳市| 麟游县| 扶绥县| 宣恩县| 安顺市| 盐亭县| 富阳市| 西昌市| 巢湖市| 中山市| 北辰区| 红原县| 柳林县| 福建省| 宣威市| 成武县| 儋州市| 泰顺县| 贵港市| 通榆县| 东阿县| 安达市| 班戈县| 太原市| 随州市| 灯塔市| 奇台县| 吴旗县| 陕西省| 大城县| 巴林右旗| 乐东| 政和县| 岢岚县| 石门县| 翁源县| 宁夏| 怀远县| 拉孜县|