- Learn T-SQL Querying
- Pedro Lopes Pam Lahoud
- 194字
- 2021-06-24 14:38:11
Understanding Query Processing
Now that we have learned the basics of writing T-SQL queries and how SQL Server interprets them, the next logical step is to understand how SQL Server processes and ultimately executes the query. The Query Processor includes query compilation, query optimization, and query execution essentials; how does SQL Server compile an incoming T-SQL statement? How does SQL Server optimize and execute a T-SQL statement? How does SQL Server use parameters? Are parameters an advantage? Why does a SQL Server cache execution plans for certain T-SQL statements but not others? When is that an advantage and when is it a problem? This is information that any T-SQL practitioner needs to keep as reference for proactive T-SQL query writing, as well as reactive troubleshooting and optimization purposes. This chapter will be referenced throughout all chapters, as we bridge architectural topics to real-world usage. The main stages of query processing can be seen in the following overview diagram, which we will expand on throughout this chapter:

In this chapter we will cover the following topics:
- Query compilation essentials
- Query optimization essentials
- Query execution essentials
- Plan caching and reuse
- The importance of parameters
- Practical Data Analysis
- 3D Printing with RepRap Cookbook
- 商戰數據挖掘:你需要了解的數據科學與分析思維
- 程序設計語言與編譯
- 精通特征工程
- Apache Spark Deep Learning Cookbook
- 中國戰略性新興產業研究與發展·工業機器人
- 液壓機智能故障診斷方法集成技術
- 基于ARM9的小型機器人制作
- Excel 2007終極技巧金典
- 人工智能:智能人機交互
- 手把手教你學Photoshop CS3
- Generative Adversarial Networks Projects
- MySQL Management and Administration with Navicat
- Mastering Android Game Development with Unity