Book description
Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, then rewriting those anti-patterns using new functionality that is supported in current versions of SQL Server, including SQL Server 2019. The focus moves through the different types of database objects and the code used to create them, discussing the limitations and anti-patterns commonly found for each object type in your database.- 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
Table of contents
Product information
- Title: Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications
- Author(s):
- Release date: January 2020
- Publisher(s): Apress
- ISBN: 9781484255810
You might also like
book
Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers
Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL …
book
SQL Performance Tuning
is a handbook of practical solutions for busy database professionals charged with managing an organization's critically …
book
High Performance SQL Server: Consistent Response for Mission-Critical Applications
Design and configure SQL Server instances and databases in support of high-throughput, mission-critical applications providing consistent …
book
SQL Server Integration Services Design Patterns, Second Edition
SQL Server Integration Services Design Patterns is newly-revised for SQL Server 2014, and is a book …