Overview
- Promotes simplicity when designing and writing T-SQL
- Shows when it is beneficial to use specialized T-SQL features
- Aids in planning for scalability and flexibility in T-SQL program design
Access this book
Tax calculation will be finalised at checkout
Other ways to access
About this book
Hands-on examples show modern T-SQL practices and provide straightforward explanations. Attention is given to selecting the right data types and objects when designing T-SQL solutions. Author Elizabeth Noble teaches you how to improve your T-SQL performance through good design practices that benefit programmers and ultimately the users of the applications. You will know the common pitfalls of writing T-SQL and how to avoid those pitfalls going forward.
What You Will Learn
- Choose correct data types and database objects when designing T-SQL
- Write T-SQL that searches data efficiently and uses hardware effectively
- Implement source control and testing methods to streamline the deployment process
- Design T-SQL that can be enhanced or modified with less effort
- Plan for long-term data management and storage
Who This Book Is For
Database developers who want to improve the efficiency of their applications, and developers who want to solve complex query and data problems more easily by writing T-SQL that performs well, brings back correct results, and is easy for other developers to understand and maintain
Similar content being viewed by others
Keywords
Table of contents (15 chapters)
-
Building Understandable T-SQL
-
Building Performant T-SQL
-
Building Manageable T-SQL
-
Building Maintainable T-SQL
Authors and Affiliations
About the author
Bibliographic Information
Book Title: Pro T-SQL 2019
Book Subtitle: Toward Speed, Scalability, and Standardization for SQL Server Developers
Authors: Elizabeth Noble
DOI: https://doi.org/10.1007/978-1-4842-5590-2
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Elizabeth Noble 2020
eBook ISBN: 978-1-4842-5590-2Published: 12 February 2020
Edition Number: 1
Number of Pages: XVII, 406
Number of Illustrations: 138 b/w illustrations
Topics: Database Management, Microsoft and .NET