Refactoring Legacy T-SQL for Improved Performance
- Author: Lisa Bohm
- ISBN: 1484255801
- Year: 2020
- Pages: 236
- Language: English
- File size: 2.6 MB
- File format: PDF, ePub
- Category: C & C++ SQL
Breathe new life into old software by refactoring T-SQL code and queries using modern techniques. This book demonstrates the way to significantly improve the performance of older software by discovering common anti-patterns in T-SQL code, then restarting these anti-patterns employing new functionality that’s supported in current versions of SQL Server, including SQL Server 2019. The focus moves through the different kinds of database objects and the code used to create them discussing the constraints and anti-patterns usually found for each item type in your own database.
Legacy code isn’t only found in questions and external applications. It’s also found in the definitions of underlying database objects such as tables and views. This book makes it possible to quickly locate debatable code throughout the database and points out where and how contemporary alternatives can replace older code, thereby making your legacy software run faster and widening their lifetimes. Author Lisa Bohm describes the logic behind every anti-pattern, assisting you to understand why each pattern is an issue and demonstrating how it can be avoided. Good coding habits are discussed, such as advice on topics such as readability and maintainability.
What You’ll Learn
- Find specific places in code to target for performance gains
- Describe pain points quickly and understand why they are problematic
- Rewrite legacy T-SQL to reduce or eliminate hidden performance issues
- Compose modern code with an awareness of readability and maintainability
- Realize and correlate T-SQL anti-patterns using techniques for better solutions
- Create a positive Effect on application user experience in your organization
Who This Book Is For
Database administrators or developers who maintain older code, those frustrated with complaints regarding slow code when there is a lot of it to fix, and those who want a head start in making a positive effect on application user encounter in their company.