Overview
- Helps to mitigate technical debt found in legacy code
- Shows how to target performance pain points commonly found in older code
- Promotes awareness of modern coding techniques yielding strong performance
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (9 chapters)
-
Everything Is Slow
-
Database Structure
-
CRUD Objects
-
The Bad and the Ugly
Keywords
About this book
Legacy code isn’t just found in queries and external applications. It’s also found in the definitions of underlying database objects such as views and tables. This book helps you quickly find problematic code throughout the database and points out where and how modern solutions can replace older code, thereby making your legacy applications run faster and extending their lifetimes. Author Lisa Bohm explains the logic behind each anti-pattern, helping you understand why each pattern is a problem and showing how it can be avoided. Good coding habits are discussed, including guidance on topics such as readability and maintainability.
What You Will Learn
- Find specific areas in code to target for performance gains
- Identify pain points quickly and understand why they are problematic
- Rewrite legacy T-SQL to reduce or eliminate hidden performance issues
- Write modern code with an awareness of readability and maintainability
- Recognize and correlate T-SQL anti-patterns with techniques for better solutions
- Make a positive impact on application user experience in your organization
Who This Book Is For
Database administrators or developers who maintain older code, those frustrated with complaints about slow codewhen there is so much of it to fix, and those who want a head start in making a positive impact on application user experience in their organization
Authors and Affiliations
About the author
Bibliographic Information
Book Title: Refactoring Legacy T-SQL for Improved Performance
Book Subtitle: Modern Practices for SQL Server Applications
Authors: Lisa Bohm
DOI: https://doi.org/10.1007/978-1-4842-5581-0
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Lisa Bohm 2020
Softcover ISBN: 978-1-4842-5580-3Published: 11 January 2020
eBook ISBN: 978-1-4842-5581-0Published: 10 January 2020
Edition Number: 1
Number of Pages: XXI, 236
Number of Illustrations: 11 b/w illustrations
Topics: Microsoft and .NET, Database Management