Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers

© Elizabeth Noble 2020

Elizabeth NoblePro T-SQL 2019https://doi.org/10.1007/978-1-4842-5590-2_5

5. Set-Based Design

Elizabeth Noble¹ 

(1)

Roswell, GA, USA

 

Knowing how to design T-SQL is part of the foundation for writing professional code. Once you can write T-SQL code that can be easily understood, you can start to focus on improving the performance of your T-SQL code. If you learned T-SQL informally as part of your job or your primary function is writing code for software applications, you may not consciously consider set-based design when writing your T-SQL code. You may be an experienced database developer and want to learn more about set-based design.

In this chapter, I want to discuss how to work with your data. The first step is to get familiar ...