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_13

13. Functional Design

Elizabeth Noble¹ 

(1)

Roswell, GA, USA

 

Over the course of this book, we have covered many different topics. Most of these chapters involve best practices. These best practices involve naming conventions, formatting T-SQL code, or designing database objects. Despite your best efforts, you may find yourself in a situation that is outside the scope of best practices. These times can correlate to periods of high stress or tight deadlines. The goal of this chapter is to help you prepare for the situations when you must make quick decisions about complex topics.

Designing database code for applications that are created to let users insert ...