- 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.
推薦閱讀
- Mastering Mesos
- 虛擬儀器設(shè)計(jì)測(cè)控應(yīng)用典型實(shí)例
- Practical Data Analysis
- 自動(dòng)控制原理
- 程序設(shè)計(jì)缺陷分析與實(shí)踐
- 網(wǎng)上生活必備
- Windows XP中文版應(yīng)用基礎(chǔ)
- 空間傳感器網(wǎng)絡(luò)復(fù)雜區(qū)域智能監(jiān)測(cè)技術(shù)
- 最簡(jiǎn)數(shù)據(jù)挖掘
- Windows程序設(shè)計(jì)與架構(gòu)
- 21天學(xué)通Java
- Learn CloudFormation
- INSTANT Puppet 3 Starter
- 漢字錄入技能訓(xùn)練
- 樂(lè)高創(chuàng)意機(jī)器人教程(中級(jí) 上冊(cè) 10~16歲) (青少年iCAN+創(chuàng)新創(chuàng)意實(shí)踐指導(dǎo)叢書(shū))